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?
HI @Anonymous
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.
Proud to be a Super User! |  |
HI @Anonymous
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.
Proud to be a Super User! | |
Helpful resources
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Join our Fabric User Panel
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Power BI Community Update - March 2026
Check out the March 2026 Power BI update to learn about new features.
