Power BI Desktop - Performance Issues

Hi zfemmer ,

I think the scenario that you have mentioned is something, most of the people who work with Big Data, face these issues.

Recently, I have worked on something similar scenario and improved the Performance by making following chnages:

• Try to remove un-necessary columns from your tables. keep only the ones used for reporting. Delete remaining columns.
• In Query Editor enable the "Enable Load" option for the tables that are used for reporting. Some-times we create refrence tables for creating bridge tables in Power BI; which are further used for creating relationships between the tables.

• If you are using visuals like a table visual, and displaying most of the rows from your dataset, then try to limit these rows by giving them a default view like - Top 1000 rows, etc. You can check my blog on this similar functionality: https://community.powerbi.com/t5/Community-Blog/Controlling-Number-of-Rows-to-Be-Displayed-in-a-Table-Visual/ba-p/1317661
• The other option could be pre-set some page level filters on your report. This improves performance of the report from loading point of view.
• Avoid bi-directional relationships in your data model. Try to adopt the approach of a Star Schema Model.
• If you are creating many calculations, try to stick to MEASURES rather than creating Calculated COLUMNS.
• Use Performance Analyzer in Power BI to check performance of your reporting tabs. It tells you exactly where your problem is - whether your DAX query takes time or visual loading takes time.
• Try to limit number of visuals on a single tab. Rather than having 20 visuals on a single tab, split them into 2 tabs having 10 visuals each.

For now I can suggest the above ways based on my experience. There are many articles out there which give insights around how performance of the Power BI dasboard can be improved.

Let me know if these help.

Thanks,

Pragati