Data & Analysis

Making One Power BI Measure Appear In Multiple Folders

Back in 2018, when I wrote a detailed post on how to create nested display folders for measures in Power BI, I mentioned that unlike in Analysis Services it was not possible to make a Power BI measure appear in two or more folders simultaneously. The…

26 March 2020

Data & Analysis

Visualising Power BI Premium And Azure Analysis Services Query Parallelism

In my last post I showed how to connect SQL Server Profiler up to a Power BI Premium dataset but I didn’t give you any examples of why this might be useful. In this post I’ll show you how you can use a Profiler trace to…

17 March 2020

Data & Analysis

Adding Your Own Messages To Power Query Query Diagnostics

A quick point: while the Power Query Query Diagnostics functionality is relatively new, it’s based on Power BI/Power Query trace logging that has been around for a while. I’ve just realised that this means you can use the Diagnostics.Trace M function that I blogged about back…

4 March 2020

Data & Analysis

Make Your Power BI Report Run Faster By Showing The Same Data In Fewer Visuals

Before we go any further, I don’t want you to go and change your reports if you’re not going to get any benefit from doing so. Use Performance Analyzer (as shown here) to determine which visuals on your report are the cause of slow performance –…

27 February 2020

Data & Analysis

Power BI desktop February 2020 is out and incremental refresh is now generally available!

Microsoft has announced the release of Power BI Desktop: February 2020 and you can read all about it here: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-february-2020-feature-summary/ I am very happy about incremental refresh, which is now generally available and is now supported for Power BI Pro licensing, meaning it is no longer…

26 February 2020

Data & Analysis

An M Function To Help You Explore Power Query Diagnostics Data

Last week’s post showed an M function that took Power Query diagnostics data and formatted in a way that made it suitable for visualisation in a Power BI Decomposition Tree visual. This is great for understanding what’s going on at a high level, but by doing…

20 February 2020

Data & Analysis

How do I: Add a drill-through to see records in Power BI Desktop?

Imagine you have created an amazing Power BI report that summarizes information using different visuals. Power BI Desktop lets you build advanced queries, models, and reports that visualize data and the idea is that the individual records that come from your data source are aggregated and…

18 February 2020