Refresh Source takes time

[Anonymous]

My weekly report usually takes 10min - 20min max but all of sudden this week it takes a lot of time , running the report from past 5 hours and its still 912MB, tried it in different system it is still slow. I am unable to figure out the root cause. Does any one have any experience or idea on the same.

[selimovd]

Hey @Anonymous ,

that's very hard to say without further details.

When you open the PBIX file and try to refresh, is there a specific table that takes very long? If yes, investigate that table further.

Otherwise, you can use the Query Diagnostics of Power Query to get a better insight:

Power BI Query Performance & Query Diagnostics | Paul Turley's SQL Server BI Blog

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Anonymous]

Hi @selimovd ,

Yes, it is a specific table but, its a weekly report, it just took 10-20min last week and this week with no additional table , no changes but takes this longer. 

[selimovd · Accepted solution]

Hey @Anonymous ,

and where is that table? In a relational table like a SQL Server or in an Excel or CSV file? Can you open the table with another tool? Does it also take long there? How many rows does it have now and how many did it have when it took 10-20 minutes? Did anything else change (Location, Index, etc.)?

You should investigate the table more, then usually things will clear up.

Best regards

Denis