SQLBits 2024
Best practices for developing Power BI reports
We will see the most important best practices in terms of performance and organization of our report/dataset in the following areas of Power BI:
-Power Query / M
-Data modeling & DAX
-Visualization
Remember that best practices are not mainly for you but for the next person working on the report you built.
In this session we will look at the most important best practices when developing a Power BI report and how these best practices can improve our life as developers.
We will differentiate best practices in the following three areas:
-Power Query / M
-Data modeling & DAX
-Visualization
Within these areas, we will see which best practices have an impact on performance and which ones help you to better organize your artifacts and improve usability of the report and readability of your code.
Remember that best practices are mostly not for you, the developer who has built this report. The main benefit is if we open a report from someone else or inherit one from a colleague, that is when you will start appreciating people following best practices.
Won't you appreciate being handed over a nicely organized report that fullfils the most important best practices? Make it your mission to stand by them when you build Power BI reports.
We will differentiate best practices in the following three areas:
-Power Query / M
-Data modeling & DAX
-Visualization
Within these areas, we will see which best practices have an impact on performance and which ones help you to better organize your artifacts and improve usability of the report and readability of your code.
Remember that best practices are mostly not for you, the developer who has built this report. The main benefit is if we open a report from someone else or inherit one from a colleague, that is when you will start appreciating people following best practices.
Won't you appreciate being handed over a nicely organized report that fullfils the most important best practices? Make it your mission to stand by them when you build Power BI reports.