How to format all dax measures in one click. How to add descriptions to your measures using Tabular Editor. Good for live reports especially

For once this is not a technical blog about a feature or trick in Microsoft Power BI. In this blog post, I want to explain the benefits and downsides of using Azure VMs instead of regular hardware. This might be especially interesting for people using MS Power BI. What is an Azure Virtual Machine? I am by no means a hardware expert but to me an Azure VM is a virtual computer that is highly flexible in its scaling (processing power, storage etc.) and at the same time offers ev

Until a few months ago, I have only worked with either Bing maps, filled maps or shape maps (these are the standard visuals in Power BI). In the last months however, more clients were interested in custom solutions for map visualizations. In this post I want to explain how to use any kind of map inside Power BI. In order to understand the map terminology, I want to throw out some things that are important to know. When I talk about a visual, I am referring to one of these obj

For me, Power BI has become a rather complete tool over the last few years. Some things are still missing though, like pop-up messages. There are no really good solutions to warn or inform users, the classic pop-up just does not exist. Imagine you have a multi-tenant/client report. Row-level security is managing who has access to which data. Now if you want to restrict access to some pages or some content it can get tricky. Maybe you need to create a warning message or set vi

This post explains how you can make your tooltip pages in MS Power BI completely dynamic to show different measures.

Automatically trigger a refresh for a Power BI Dataset when a Dataflow refresh completes. This can be achieved easily using PowerApps.

How do you correctly calculate a Delta % YTD or just a percentage change of two values? Check out my Power BI Blog post for a DAX solution

Power BI Dataflows are still pretty new to most. I think it is amazing that Power Query has moved to the cloud and you can use it with a Power BI Pro license only. Some things are better than in the offline version of Power Query, like new automatic transformation steps or suggestions for transformations. Some things however are problematic, like time intelligence and restrictions on which data types you can output. Microsoft's documentation is very patchy as well. It is e.g.

One of our clients recently asked us to find a better solution for forcing users to select a filter value. They had this: The first problem here is that the customer used ISFILTERED instead of HASONEVALUE. None of their users should be allowed to select multiple values, with ISFILTERED this is possible though. Secondly, this solution which is found a lot on Power BI blogs and community posts has one huge downside: You have to put the message (it is a visual itself) on top of

When you import publicly available data into your report you will most likely use the web connector in Power Query. This might lead to issues later on when trying to refresh your dataset. Here is why: When you select the Web connector in Power BI (or Power Query) to load publicly accessible data (with anonymous authentication) This function will be automatically created: = Web.BrowserContents("MYURL") This will lead to issues when you publish your report to the Power BI Servi

There are some data type changes that can be performed without breaking query-folding. We tested this with SQL Server 2016 as a data source

Transforming your custom fiscal dates to number format and then generating a list of values between them will give us all dates in between.