BI Inside
All articlesPower BIDAXVisualizationModelDataM-QueryPower BI ServiceOtherEverything with AI
All articles
Newest first
-
The importance of custom totals
In the march 2026 update of Power BI, Microsoft gave us a new feature that has been a bit underexposed. It does…
-
ISFILTERED
You probably know that the ISFILTERED function returns TRUE when the specified table or column is being filtered directly. But did you know that…
-
Un-Bold Row Headers
Have you ever created a matrix visual, with hierarchy, where your row headers are formatted 𝐛𝐨𝐥𝐝? You can not seem to turn…
-
Alignment of visuals
Have you ever heard of the “Align” button? It helps you to align visuals, no more precision drag-and-drop… It also helps to…
-
Why you want to avoid a many-to-many relationship?
The Power BI data model is one of the most important aspects of a good Power BI environment. The data model is…
-
Value filter behavior
To quote the explanation of Microsoft: When you are filtering multiple columns on the same table, the current default value filter behavior…
-
Folder structure for measures
if you use a semicolon (;) between folder structures, you can show that measure in multiple folders…
-
Calculation Groups
I wrote a calculation group C# script so that you don’t have to …
-
The set up of Power BI service
In the Power BI service, one can publish reports, so that it is available to end users. Here one can also add…
-
A datamodel based on practice
In order to arrive at a good and efficient data model, it is important to understand the proces of normalization in combination…
-
Download a Power BI dataset with XMLA endpoint enabled
https://docs.tabulareditor.com/te3/powerbi-xmla-pbix-workaround.html#convert-incremental-refresh-partitions Source: Tabular Editor docs.
-
USERELATIONSHIP vs TREATAS
Example: They want to use a different relationship than the one that already exists. A table can only have one (active) relationship…
-
FILTER vs KEEPFILTERS
Example: Only customer A needs to be visible. To be able to see only customer A, you can use the expression FILTER…
-
ALL vs RemoveFilters
Example: They want to see the total for all customers. The purpose of the ALL expression is to ignore any filter that…
-
Calculate
The CALCULATE expression is perhaps the most important expression in the DAX library. The CALCULATE expression can be used to modify existing…
-
What does the X stand for in SUMX?
The X stands for iteration expression. Iteration means that Power BI will no longer calculate the total or max of a single…
-
Incremental refresh
Incremental refresh involves dividing a large data set into different parts based on periods. The renewal of the dataset can be set…
-
Part 2 – Bulk-copy pages
In part 1 of this series, we used DAX – scripting to bulk-copy measures. The next step is to bulk-copy pages with…
-
Part 1 – DAX scripting
There is a data model. This data model consists of one (1) dimension table and three (3) fact tables. Each fact table…
-
Data source (methodology)
Introduction Microsoft Power BI is originally a data visualization tool. It cannot function without a data source and therefore it is crucial…
-
Third party tools
A third-party tool is a piece of hardware or software developed by a company other than the product manufacturer and designed to…
-
Solving a data error message.
A beautiful dashboard has been created, but according to the end user of the dashboard, the data is incorrect. The cause is…
-
The Definition Of A Gateway
You have probably heard about the phrase “gateway”. But what is meant by this phrase? In an easy explanation: a gateway is…
-
Fixing The ALL Function
If you use an ALL function on a column that has a sorting by column applied, you also need to take that…
-
Format DAX
You can format all your DAX measures at once. No more single-handed formatting every measure one by one. To format all your…
-
Keyboard Shortcuts
Power BI desktop has a lot of keyboard shortcuts. This can make your life so much easier when you are developing on…
-
Field Parameters
Do you want to change the fields in your table visual or matrix visual by slicer selection? Did you know you can…
-
Resources Excedeed
Did you ever run into the error where your visual exceeded resources? I wrote this article to help you with this error.…
-
Row level security
What is row level security? Power BI row level security (RLS) is an user authorization and security method for a Power BI…
-
Sharepoint .Folder Or .Contents?
Sharepoint.Contents is faster then Sharepoint.Folder. This is because Sharepoint.Contents does not load all the unnecessary folder metadata. Sharepoint.Contents does require a special…
-
Dax Studio DMV
With Dax Studio DMV you can easily retrieve and extract information about your Power BI model. For example: If you want an…
-
Date Table
A custom date table could be very handy in Power Bi? The build in power bi date table does not always do…
-
Power BI Sample Datasets?
Power Bi service provides sample datasets? These datasets are perfect if you want to try out Power Bi, but don’t have sufficient…
-
Power BI MetaData
Power BI is secretly hiding a treasure full of data? With DAX Studio (DMV) and the Power BI pbix. desktop file you…
-
An introduction to Power BI
I would like to start with an introduction. My name is Marnix Pot. I work as a BI consultant at Kasparov Finance…
Downloads
Free scripts & templates
Ready-to-use files that go with my articles.
Power Query (M) · .txt
Sharepoint.Contents
Sharepoint.Contents vs. Sharepoint.Folder, side by side.
Dataflow · .json
Full dynamic row-level security
A dataflow for fully dynamic row-level security and workspace access.
Tabular Editor C# · .txt
Calculation Groups C# Script
A C# script that creates calculation groups in Tabular Editor.
About the author
Marnix Pot
BI consultant at Kasparov Finance & BI, working on business intelligence, data warehousing and AI.