8 hours to refresh

Power BI Online Service
1

Hi all,
If someone told you their report is taking 8 hours to refresh to a MS Azure SQL Server,
a) what would be your high level process to start investigating the issue
b) what things would you consider was perhaps done incorrectly to glean such a large refresh timeframe
c) what methods would you consider to improve the refresh timeframe?

Your experience and assistance / advice would be greatly appreciated.

Regards
John G

2

Hi @jgriffit,

Start at the beginning…

  • Can work be off loaded to the datasource? (if not consider Dataflows for slow sources)
  • Which Connector is used?
  • Is Query Folding possible and/or happening?
  • Limit data to only the absolute minimal required number of Columns and Rows, early on
  • Perform Query Diagnostics
  • Look for optimization of expensive transformations (use Diagnostics to confirm)
    .

.
I hope this is helpful

1 Like
3

Very helpful thanks Melissa !

4

Did Melissa’s response solved your question, @jgriffit ?

Please don’t forget if your question has been answered within the forum it is important to mark your thread as ‘solved’.

We request you to kindly take time to answer the Enterprise DNA Forum User Experience Survey, We hope you’ll give your insights on how we can further improve the Support forum. Thanks!