Forum Discussion
Helper III500 mb pbix slow loading
Hello experts!
I have a problem with me pbix, when i open on my local pc its working fast, everything load fast (in performance analyzer the max time after refresh is 6385ms), but when i do this same on service, report loading is two minutes, and after that i se loading of first visuals.
My pbix weighs 500mb, do you have idea how to improve it ?
Hi hylosko ,
Below are the usual methods for making your report high-performant:
1. Optimising DAX with appropriate DAX functions2. Removing unwanted columns
3. Removing unused columns
If these doesn't speed up your report, you can contact your admin to push the workspace into Corporate capacity where the report will load much much faster.
Your report in desktop takes the data from Cache, hence it loads faster in desktop sometimes when compared to services.
Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!
Proud To Be a Super User !!!
LinkedIn
4 Replies
- Anand24
Super User
Hi hylosko ,
Below are the usual methods for making your report high-performant:
1. Optimising DAX with appropriate DAX functions2. Removing unwanted columns
3. Removing unused columns
If these doesn't speed up your report, you can contact your admin to push the workspace into Corporate capacity where the report will load much much faster.
Your report in desktop takes the data from Cache, hence it loads faster in desktop sometimes when compared to services.
Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!
Proud To Be a Super User !!!
LinkedIn
hyloskohmm actually Im admin of this workspace, so can you show me how to set that capacity ?
- Anand24
Hi hylosko ,
This admin is different from the "Admin" role of a workspace.The corporate capacity can be enabled only by the Power BI Administrator of the organization.
You can connect with them and they should be able to perform the needful.
Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!
Proud To Be a Super User !!!
LinkedIn