Power BI

Embed Power BI Goals in your app With data flowing from every corner of an organization, it is easy to get lost in a sea of information where key data points are sprinkled across scattered reports and dashboards. Goals is a new Power BI feature that helps individuals, teams, and organizations keep t...

Modify the formula of an article answering a reader question: How to compute the last 6 months of transactions using the last transaction date of each custo

This article explains how the CONTAINS function works and what can be used as better alternatives in DAX in common use cases. The CONTAINS function in DAX h

Data mapping with table connected to the dataset streamlines the process of data mapping to ensure all values are mapped with minimal effort.

You probably know that it’s a best practice to build your Power BI datasets in a separate .pbix file from your reports – among other things it means that different people can develop th…

Welcome to the August 2021 update, can you believe that it’s August already?! In this update we have exciting new things for Q&A as well as for Shapes. Also, new this month is Automatic aggregations for DirectQuery. There is more to explore, please continue to read on.

We often have our data spread out in different Excel workbooks and sheets. How do we combine all of them into one table? Let’s walk through an example. We have our data saved in a folder with three files: 2019.xlsx, 2020.xlsx, and 2021.xlsx. You can download the files here. Each file contains three sheets: AC, …

Have you ever wondered why a Power BI dataset refresh was taking so long? And more specifically, how much time did the refresh spend on various sub-tasks that aren’t that visible to you via the …

I’m pulling data from GitHub Codeowners into a Power BI report. All was dandy locally, but refresh failed on the PBI service with this:This dataset includes a dynamic data source. Since dynamic data sources aren’t

A new look for the Power BI in-product store coming with August release!  In the store you can browse all the visuals authorized by your organization.

A full, easy to install Power BI Version Control solution allowing source control, check ins and local editing. Download for free now!

We are excited to announce that the Power Query forum is now available in both Power BI and Power Apps communities!

A quick note for anyone like me who spends too much time looking at the JSON exports from Performance Analyzer in Power BI Desktop: you may have noticed an event called Query Pending that isn&#8217…

This article continues to build on my COVID Case Fatality Rate report for Australia. Something happened with the global source data this week – in short, it was wrong. This is a global database and I am sure there are many people diligently trying to keep the data up to [...]Read More »

We are super excited to announce that digital copies of Master Your Data for Excel and Power BI are now available for purchase!

I love using my data patterns to solve issues and in this post use one of my favourite recipes in order to label duplicates with Power Query.

I was inspired into action this week by one of the worst visuals I have seen during the COVID pandemic. Here is the visual below, take a look and see what you think. When I first saw this chart, I simply couldn’t make sense of it. The first thing I [...]Read More »

Learn how to know your dataset better using column profiling, quality, and distribution features of Power Query in Power BI

Learn how to find similar values in the data table based on a similarity threshold and get the similarity score output with fuzzy clustering.

When comparing AAS to PPU, I show which are the different deployment options and suggest which ones will work best.

Being aware of data problems is the first step towards solving them. Instructions to create data problem button efficiently with a Tabular Editor script.

This post discusses the forms, origins, and indications of fraud and misrepresentation in the context of Power BI consulting and contract engagements. The intent of this content is to help the read…

When working with Power Query, you have probably already realized that every expression you write returns a value of a specific type. Usually this will be a primitive type like text, number, or date. (A full list of types available in Power Query can be found here: https://docs.microsoft.com/en-us/powerquery-m/m-spec-types). If for some reason the type of…

Power BI deployments are resource-intensive projects that require managing many moving parts and competing priorities. Plan for success with this approach.

Did someone ask you to replace blank values with 0 in your reports? Maybe you should think twice before you do it!

Updated announcement for Premium Gen2 General Availability

[vc_row][vc_column width="1/1"][vc_single_image media="88206" media_width_percent="100"][vc_column_text]In this Power BI tutorial, you'll learn how to build a correlation plot natively in Power BI. […]

Using Smart Narratives and you’d like to add some conditional formatting in Power BI? Patrick shows you some tricks to take Smart Narratives to the next level! Download Sample