Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I would like to know more about the refresh mechanism in Power BI. I have tried to use Refresh in Power BI desktop. But, everytime it never successfully loading(it still did not end the loading after many hours. Instead, I have to make some slightly different change/add a step that is not quite relevant but keep the result in order to load the new data, and I think this is quite annoying. Do anyone know how to load the new data in the most efficient way?
Solved! Go to Solution.
HI @Hayoung
The refresh depends on data size in individual table.
If your datasize is big, you should try Query folding and Incremental refresh
https://www.youtube.com/watch?v=5AWt6ijJG94
https://www.youtube.com/watch?v=fZVtlckIYvY
If you have multiple table and all table is not require to refresh every time (static data), you can use below feature in Power Query
https://pbivisuals.com/2021/02/18/enable-load-include-in-report-refresh-in-query-editor/
If solve your requirement, please mark as SOLUTION and like this comment.
HI @Hayoung
The refresh depends on data size in individual table.
If your datasize is big, you should try Query folding and Incremental refresh
https://www.youtube.com/watch?v=5AWt6ijJG94
https://www.youtube.com/watch?v=fZVtlckIYvY
If you have multiple table and all table is not require to refresh every time (static data), you can use below feature in Power Query
https://pbivisuals.com/2021/02/18/enable-load-include-in-report-refresh-in-query-editor/
If solve your requirement, please mark as SOLUTION and like this comment.