Power BI is a robust tool to build dashboards from your data. The drop and drag interface executes it fast and easy to design a simple dashboard from scratch. Yet, once things get more complicated, and you add more extra widgets, your dashboard's execution might get reduced to a crawling step.

1. Use Integers Whenever Possible

finding through rows of numbers is a faster way than searching by strings. So when possible, do use integers. For example, it would be enough to use 0 / 1 values alternatively of "Yes/No." Or 1/2/3 rather than "low/medium/high". And be cautious, because a digit is not certainly an integer. You can have 1/2/3 as values, but they can yet be counted strings. So always check the data form in the query editor.

2. Remove Anything That Is Not Used

Whether it's columns, tables, or rows, if you are not utilizing it, it won't be in your dashboard. So while data (pre)-processing stay to what you want for your dashboard, everything else will only slow down performance.

3.Stick To The Default Power Bi Widgets

The Power BI marketplace is a vast resource for searching amazing widgets to show your insights.then also, sometimes, you have no alternative, but to use them, I would recommend you stay to default widgets if you have the option. If that facilitate third-party widget looks slightly more reliable but reduce the speed of your dashboard, you should ask yourself the question if it's worth using it. I'm not stating all marketplace widgets are slow, but some of the significant speed enhancements I made were by turning back to default slicers.

4. Use Tabs

implementing tabs will not only enhance performance but will maybe decongest your dashboard. If you find yourself surprised by the number of charts, slicers, and cards on your dashboard, it sways smart to split them into subtopics/themes, etc. and place them in another tab. By combining your filters across different tabs, you can have your slicers, creating tab A filter tab B or vice versa. The dashboard will be faster AND better viewing.

5. Use Top-N Rows In Tables

A big table can create the quickest dashboard crawl. Each time you utilize a slicer, the table will have to display and generate all the data in the dataset. Due to this, Microsoft included the convenient "top-n rows" feature. When turn-on, rather than showing the entire dataset, the table will define itself to N rows. Again, a straightforward intervention that will yield significant improvement.

To Measure Is To Know

Microsoft attached a new feature in it’s most advanced (May 2019) Power BI update: the performance analyzer. This innovative tool allows you to analyze the rate of your dashboard and will point out the issues. It works by recording your activities when utilizing the dashboard and timing the load times for each widget. Once you finish the recording, you get a detailed overview with a loading duration for all widgets.