Refresh time

[Richard76]

Hi Folks,

I am currently importing circa 1million rows of data via an SQL server in to my reports and it can take up to 6 minutes to update every report (7 in total) . Is it normal to take this amount of time does anyone have similar data loads to compare ??

Thanks

Richard

[Mariusz · Accepted solution]

Hi @Richard76 

The below will help you to get better performance on load, "Remove useless columns" and "Split date and time" probably most relevant here.

https://www.sqlbi.com/articles/data-import-best-practices-in-power-bi/

If you want to understand what happens when you load the data, please read the below.

https://www.microsoftpressstore.com/articles/article.aspx?p=2449192&seqNum=3

A lot of other factors has importance too, like.

• Does it happen in PBI Service or Desktop  
• Where is the data source located vs where is the service located 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.