Refresh data keeps loading for an hour

[Chanleakna123]

hi all , i have the same source with the other dashboards too . but it looks fine when refreshing the data . 

but this dashboard , when i refresh , it keeps loading for an hour , i am trying to figure out the root cause . but no result. 

the source of the data is on my desktop and it looks good. 

can you all tell me how to settle this ? 

[v-yingjl]

Hi @Chanleakna123 ,

If you've fixed the issue on your own please kindly share your solution. If the above posts help, please kindly mark it as a solution to help others find it more quickly. Thanks!

Best Regards,
Yingjie Li

[v-yingjl]

Hi @Chanleakna123 ,

Potential reason that cause this issue could be that your data source is large and there is too much complex query in the visual.

Please try to use Performance Analyzer to check how each of your report elements performs when users interact with them, and which aspects of their performance are most (or least) resource intensive. Refer this document: Use Performance Analyzer to examine report element performance 

In addition, you can try to optimize your model and query in power bi, here is a guide for optimization in power bi that you can refer.

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[mwegener]

Hi @Chanleakna123 ,

maybe you can find out something with the Query Diagnostics.

https://docs.microsoft.com/en-us/power-query/recordingquerydiagnostics