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