Power BI

Last week I was re-awarded as a Microsoft MVP (This is the third year now) and I am so grateful. The Microsoft Most Valuable Professional award is a unique program (Learn more about the program here).…

Navigating from a Power BI report to an SSRS Paginated report with filters and parameters. This recipe primarily involves Power BI report design techniques. I’m not going to get into the details of…

This morning I discovered a great new features in PowerApps. In the past we got these little red circles with white crosses, but now they come with a little drop down menus. The Edit in formula bar ge…

Although the conditional formatting by rules feature in Power BI was released a long time ago, one very common cause of confusion is with how to implement basic “greater than” or “less than” rules. Fo…

I was doing some online shopping last week and saw a price slicer with a histogram to show the concentration of price points. I thought it was pretty cool, so decided to see if I could build this …

Introduction For this blog, I look at a method to take some text in the form of a horizontal sentence and use DAX to pivot the text into a vertical list of words. The PBIX file for this exercise ca…

Have you ever wished to see what all the variables in your DAX code contain? Debug DAX variables with the function presented in this article.

By This blog post explains how the REST API can be used to prepare the Power BI Inventory Report. On this inventory report, we can show below items which almost covered all the contents from Power BI.…

This blog talks about the recently enabled feature “Multiple data source definitions to the same data source”

As mentioned in Part 1, AI Builder is a game changer in Power Apps and Microsoft flow. In this post, I am going to show how you able to access the AI Builder for classification. to see how to set up y…

There is a new announcement in the Business Application Summit about AI Builder! So what is AI Builder? Power Apps has been here for a while, it helps none developer people create their own applicatio…

I have written a long time ago about sharing a Power BI dataset between reports, in an article written when the feature announced first. Nowadays, if you are in the world of Power BI, you heard a lot …

Let’s take a look at the new shared and certified datasets feature in Power BI Desktop and the Power BI service. This opens up a lot of possibilities and helps to reduce data silos.

Thanks for watching this week’s Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup143 Tech Video: https://guyinacu.be/shareddatasets Source Showing only slicer data that have facts…

The viewer role for Power BI App Workspaces is now available! Now, let’s look at Power BI Apps vs. App Workspaces and have a discussion around which is the better way to go for content distribution in…

We’re two weeks post-GA of Paginated Reports in Power BI, and we wanted let you know about several updates we’ve made since then

As a Power BI service admin, do you frequently need to list all workspaces in your tenant, and all reports, dashboards, and datasets in those workspaces as well? If the answer is yes, you pro…

To kick off July, we’ve dropped the latest update to Power BI Report Builder in the download center. It includes, for the first time, the ability to browse your Power BI workspaces and …

Make sure you apply your Power Query steps the right way. Don't let date columns ruin query folding in Power BI!

Whoa! I can’t believe it is summer and almost 4th of July! It’s been WAY too long since I’ve blogged – I’ve just been SUPER busy here at P3! But I can’t let my Pug Meme readers down It seems that Micr…

An interesting – if obscure – fact I learned recently is that a small number of DAX functions such as Median() do not work on tables with more than 2 billion rows in Analysis Services Tabular, Azure AS…

A quick Q&A-related tip. If you create a report in Power BI Desktop and use a Power BI service live connection: …and then you put a Q&A button on the report, clicking on the button gives the following…

In this webinar I discussed designing a Power BI model to plan for either a simple or complex row level security scenario.

There was a new feature released in the June 2019 version of Power BI Desktop that I really like and I think warrants some explanation and review. The new feature allows you to pre-filter a slicer…

This is a short story of how I ruined one of my Power BI Desktop files. Luckily I stored it on SharePoint where I have versioning enabled, so I could restore a working version. In that Power BI rep…

How, when and why to use recursive functions within Power BI / Power Query. Theoretical and practical examples

In the last few weeks I've seen a spike in questions related to the integration of Power BI dataflows and Azure Data Lake Storage Gen2. Here's a quick "status check" on the current state of this featu…

With PowerApp Portals scheduled to release soon we wanted to give you a primer on what the getting started experience will look like and get you ready for this exciting new technology. If you are not familiar with PowerApps Portals it adds the ability to PowerApps to build low-code, responsive websi...

As an ISV (Independent Software Vendor) and consultancy services provider specialising in Office 365 and the PowerPlatform (Flow, PowerApps and PowerBI), we spend a huge amount of time with our customers defining strategy, reviewing best practices, building solutions, fixing issues and of course rev...

This article explores the properties of calculation groups in detail and then it describes how a calculation item is applied to a measure. Before starting,