Forum Discussion

syasmin25's avatar
syasmin25
Icon for Helper V rankHelper V
4 years ago

Reports running very slow

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 d...
General Comment
Need Help
Show and Tell
Tips and Tricks
GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
4 years ago

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.

syasmin25's avatar
syasmin25
Icon for Helper V rankHelper V
4 years ago

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?

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    4 years ago

    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!