Power BI – Seven Types of Table Joins
Hits: 9576This article “Seven types of table joins” was written in preparation for a user training and I don’t want
Read more
Power BI – Display Measures for specific users only
Hits: 3088The use of user roles is an essential element for restricting or preventing access to the data. The following
Read morePower BI – reduce the number of measures using color saturation
Hits: 1956When displaying value changes over time, the past values, the current values and the planned values are often in
Read morePower Query – Adding leading zeros
Hits: 3831In this short article, I’ll show you how to use Power Query and Power BI to populate values with
Read moreOpening the same PowerBI file multiple times….
Hits: 1326Today, I opened accidentally twice the same PBIX file. The standard behaviour would have been an error message, saying
Read moreIn column calculations
Hits: 1150If you want to perform calculations in Power Query, usually you have to add a new column and delete
Read moreExport datasets from Power BI Service to CSV using VBA
Hits: 3747Downloading a Power BI Dataset with VBA wasn’t really a thing I planned to do until Microsoft released the
Read morePower BI Project Checklist
Hits: 2384Just preparing for the next BI project, I thought that maybe it would be useful for Power BI users
Read moreIterating over an unknown number of pages in Power Query – avoid endless loops
Hits: 1704The topic of Iterating over an unknown number of pages in Power Query has been covered many times. The
Read moreQuick Measures in Power BI Desktop
Hits: 3697With the Power BI Desktop April 2017 release (see here), Microsoft introduced a few game changers. There are Quick
Read more
