Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Long Refresh

Hi,   I have a kinda big power bi desktop model (880mb). When i schedule a refresh on the service sometimes it work and sometimes it fails on timeout.  My question is how can i tell what table ta...
  • v-kkf-msft's avatar
    v-kkf-msft
    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.