Hi Experts,
I have made a power bi report at office, i cannot share the file as it does not allow me.
I have a data of 650,000 rows and put simple DAX measures and used measure branching in the report.
The issue is the report performance is slow, one page i have around 15 visuals.
I need your guidance that how can i optimize the performance of the report.
Also, can you please advise which course from EDNA i can take to specifically address this issue.
Thank you so much.
You’d really need to provide a little more than, “report performance is slow” to get meaningful feedback, but here are a few things that I do when I experience this:
You could start by disabling the load for unneeded tables and removing unused columns from your data model.
If you have 15 visuals on a page I’m assuming they all need to interact. Perhaps you could try combining separate visuals into a single visual. Either by layering multiple elements into the same visual (adding series, adding additional axes, encoding additional dimensions in color) or faceting or the like. Each visual executes a query. If you have a bunch of visuals, each one may be loading slowly simply because they are waiting on other queries to fire off.
You say your measures are simple. Maybe they are simple but perform poorly and a more efficient way exists. Or maybe you repeat calculations that you could do just once and re-use. Maybe there are some things you could push closer to the source.
You can explore why the visuals are taking so long using the Performance Analyzer and running those queries in DAX Studio. See where the bottlenecks are.