500 mb pbix slow loading

[hylosko]

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 ?

[Anand24 · Accepted solution]

Hi @hylosko ,
Below are the usual methods for making your report high-performant:
1. Optimising DAX with appropriate DAX functions

2. 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

[hylosko]

hmm 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

[hylosko]

oh ok, I understand now, thanks for help 🙂