Power BI slow backend refresh

[SBGoh]

Hi,

I am using Power BI desktop to create my reports. So I loaded my data source from Azure SQL DB.

My data is about 10 years and contain millions of records. Actually I only need 2 yrs data. I did some filtering in Data Transform by only choose the fields I want from each tables, but I realized when I want to make some change to the fields like change data type or trimming, it will try to refresh all the tables and it is very slow.

Is there way to speed up the data refresh ?

Does anyone encounter same problem as me? Thank you!

[amitchandak · Accepted solution]

@SBGoh , first of make sure you filter for 2 years and are folding to the data source.

https://blog.pragmaticworks.com/power-bi-checking-query-folding-with-view-native-query

Ideally, in a power query, it should not make a difference.

In the case of Visualization Studio or DAX, you can use pause visual to speed up

Always prefer to load less data on Desktop - Refer to Guyinacube

https://www.youtube.com/watch?v=qZOEDBedATA

https://www.youtube.com/watch?v=_zYvybVMk7k

[SBGoh]

Hi @amitchandak , interesting videos. Thank you!