Forum Discussion
Refresh data keeps loading for an hour
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 f...
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.