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 not clear. It can be due to several factors; or the data itself, the different parts of the Power BI dashboard , an external factor such as a page filter, a wrongly chosen […]
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 a (data) bridge between an on-premise data source and a Microsoft cloud service. These cloud services include Power BI, PowerApps, Power Automate, Azure Analysis Services, and Azure Logic Apps. An one-premise data source […]
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 sorting column into account.
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 measures at once you will need Tabular Editor 2 (free). You can then run the c# script:Model.AllMeasures.FormatDax();
Keyboard Shortcuts
Power BI desktop has a lot of keyboard shortcuts. This can make your life so much easier when you are developing on a Power BI Report. I myself always use Ctrl + Shift + L (select all occurrences of current selection in a DAX measure). But there are so much more shortcuts which could help […]
Field Parameters
Do you want to change the fields in your table visual or matrix visual by slicer selection? Did you know you can use the option field parameters for this. Field parameters gives you the option to choose your fields by slicer selection. Assume that your data model would look something like this. You have a table with […]
Resources Excedeed
Did you ever run into the error where your visual exceeded resources? I wrote this article to help you with this error. But before we start it is important to know what causes this error. Root cause Behind all the Relationships, DAX queries, Filters and Shiny Visualizations in Power BI there is code (queries). That code is making sure that everything you have […]
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 dataset. It will make sure that users with viewer permission in the Power BI service workspace will have limited or specified access to the data in the published Power BI dataset. What does […]
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 M query code + 2 parameters (sharepoint / sourcefolder).
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 extraction of all your measures? Open DAX Studio and at the tab DMV click on TMSCHEMA_MEASURES. Run the SQL select statement… DAX Studio will then give you an overview of all your measures. […]