Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I am having issues in trying to open any report from our workspace. It has been taking very long lately. I was wondering what could the possible issue be here? It is running smoothly on the desktop file however, whenever I try to open it from the workspace, it runs really slow. Same applies to guest users on the workspace.
Hi, @syasmin25
Inefficient design of reports can lead to these problems. Report pages contain too many visuals (interactive filtering can trigger at least one query per visual). Visuals retrieve more data than necessary.
Solution: Redesign reports with fewer visuals per page.
High memory usage may be a result of insufficient capacity resources.
Solution: Decrease the model size, or convert to DirectQuery mode; Scale-up the capacity; Assign the content to a different capacity.
Regarding the optimization model.
At the datasource layer:
At the model layer:
This is the relevant document, hope to help you:
https://docs.microsoft.com/power-bi/admin/service-premium-capacity-optimize
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I'm having the same issue the last few days.
Reports are opening very slow.
Hi @wouterDefour ,
I'm having too the same issue since Monday approximately.
Have you find a solution to this problem ?
Hi @syasmin25
Are you using Power BI Premium at all or just Power BI pro?
And is your model using a star schema?
The weird thing is that for example, I looked into the usage metrics report for one of the reports and this is what I see.
However, it is taking over 10 mins lately for all users.
Hi @syasmin25
I would look into the Premuim Metrics App to see if the capacity is being overloaded?
That would be my assumption and that is why the reports are slow because other reports have to be evicted before your report can then be loaded into memory.
What you could do if the report is not to big, upload it to a Power BI Pro app workspace and see if the performance is good there. If it is then there is an issue with your Premium Capacity.
Hi,
Thank you so much for your response, after testing, we were able to determine that it was issues with high query lag and memory usage. I was wondering what steps can mostly cause this issue?
Is it performing a lot of the steps in query editor or the dax calculations that does a lot of lookup? Or would it be snowflake schema?
Hi @syasmin25
This appears to be both a data model challenge where you need to model your data in a star schema with facts and dims.
This will then allow your DAX measures to be easier and simple to create the calculations. The combination of both of these will mean much faster queries using less memory!
We use PowerBI Premium and most of the reports have star schema.
Thank you so much for the prompt response. I was thinking about that, however, I do not really know how to exactly determine that. Users from other locations within the same city are also having issues while trying to load the reports.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
60 | |
20 | |
18 | |
18 | |
9 |