Forum Discussion
Long Refresh
- 4 years ago
Hi Anonymous ,
You can try the Performance Analyzer or DAX Studio to see the execution time of queries and find the queries that take the longest time to optimize.
Analyzing a slow report query in DAX Studio
In addition, you can try this way to calculate the refresh time for each table.
How to track refresh time in Power BI Desktop
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks, i will look it up and hope it works.
But i would still like to know if there is a way to know what takes longer to refresh? so i wil know where to focus first.
- v-kkf-msft4 years agoCommunity Support
Hi Anonymous ,
You can try the Performance Analyzer or DAX Studio to see the execution time of queries and find the queries that take the longest time to optimize.
Analyzing a slow report query in DAX Studio
In addition, you can try this way to calculate the refresh time for each table.
How to track refresh time in Power BI Desktop
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.