Power BI

Now that we have introduced the technology in the previous blog post, Introduction to Power BI Dataflows, this post will cover topics about the authoring experience, some important considerations, basic architecture, and Do’s and Dont’s.

When users click Analyze in Excel in the Power BI service, the generated Excel workbook is automatically saved to OneDrive for Business and the workbook can be directly opened in a web browser using Excel for the web.

Recently, I have had a challenge at a customer, where a central teams maintains many dataflows in Power BI, to store their only and single version of the truth. However, this central team maintaine…

This blog post shows the users all the Power BI reports they have got access to, and details the steps in Power BI Desktop.

Struggling with using Row-Level Security (RLS) together with Object-Level Security (OLS) in Power BI? You think it can’t be done? Think again! Patrick shows you how to use both together. Announcement Blog: https://powerbi.microsoft.com/blog/object-level-security-ols-is-now-generally-available-in-power-bi-premium-and-pro/ Analysis Services Doc: https://docs.microsoft.com/analysis-services/tabular-models/object-level-security FourMoo: https://www.fourmoo.com/2020/05/26/did-you-know-you-can-now-selectively-show-report-pages-for-specific-users-in-power-bi/

Shared Datasets have been around for quite a while now. In June 2019, Microsoft announced a new feature called Shared and Certified Datasets with the mindset of supporting enterprise-grade BI within the Power BI ecosystem. In essence, the shared dataset feature allows organisations to have a single source of truth across the organisation serving many … Continue reading Thin Reports, What Are They, Why Should I Care and How Can I Create Them?

Do you fancy a quick data visualization for your ad-hoc queries over SQL pools in Azure Synapse Analytics? Synapse Studio gets you covered!

We continue to iteratively improve experiences that help you find relevant content and return to your work in the Power BI service. Upon hearing your feedback, conducting usability tests, and running …

DESCRIPTION 📄 Do you have a lot of reports but are still searching for answers ? Do you really know what you are working toward? If so, we need to talk about Power BI Goals and how they can transform how you approach the question , where are we? GUEST BIO 👤 Treb Gatte is a bus

new data source and gateway management experience in Power BI

In this folder, you will find the source code for the PowerBI app report on Dynamics 365 Business Central telemetry in Azure Application Insights.Note that the app is still being testing in a beta …

TL;DR : When using SQL Queries against Dataverse, add the ‘[EnableFolding=true]’ option in Power Query to ensure queries are 'folding' back to the Dataverse service to gain dramatically improved …

Really cool updates for #MonkeyTools for #Excel by Ken Puls from Skillwave Training . This is a “must have” tool for everyone using Excel on Daily basis...

Power BI just launched a new Known Issue page!

Since its inception, Power BI has been a leading tool in self-service analytics. This week at Build, Microsoft released an exciting new feature available to preview – Power BI Datamarts! Power BI Datamarts enable self-service users to build and distribute an analytical solution from end-to-end. Data ingestion and preparation, data exploration and analysis, data modeling, and report design can all be done in a low- or no-code experience in Power BI Service!

Case I have one big Power BI dataset with multiple source tables and one of those source tables is refreshed once every hour and all the ot...

ABSTRACT 📝 At the end of last year , one called ExecuteQueries was added to the endpoint portfolio in the Power BI REST API . It is an endpoint that allows you to extract data directly from datasets . Although it also brings limitations, I think that its advantages outweigh them. So what

I show you how to create a Power BI report with a dashboard and a Power BI Alert when there are new additions to the known issues.

General availability announcement for Enhanced Refresh with the Power BI REST API. Perform fine-grain refresh operations for improved scalability.

In amongst all the announcements at Build recently, you may have heard about a new member of the Power Platform being launched: Power Pages. You can read the docs here, and there’s a good, de…

Power BI Architecture with separate layers: In a Power BI report development cycle, we can have separate layers since we can use many components to build report files which facilitates the re-usability of elements for better integration. we could have data preparation , data modeling and data visualization layers, such as:

Metric and goal setting is paramount when formulating business operations. That's why Microsoft Metrics (previously known as ‘Goals’) make it possible to keep every member of a team striving toward a singular, unified key objective and ensures a higher probability of positive outcomes. In fact, in this study regarding goal setting and optimism, it is shown that the goal setting process assists individual workers to improve their performance and enhances optimism for business success. So, how can productivity metrics and business objectives be met while also integrating the latest and greatest data analysis technology available? In this blog, we will be performing a deep dive into the world of productivity within Power BI’s Metrics and Scorecards.

Learn how to use Datamarts in Power BI. They enables you to store and explore your data in a relational and fully managed Azure SQL DB.

Preview data is now available!

I noticed Adam Saxton post a tip on the Guy in a Cube YouTube channel about publishing reports from Power BI Desktop for external users. According to Microsoft Docs (as of June 21, 2022), you can&#…

In this blog post I show users how to document all their Power BI Row Level Security Roles & store the output in SharePoint