Forum Discussion
Power BI slow backend refresh
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!
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
2 Replies
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
Hi amitchandak , interesting videos. Thank you!
