Hi @hoosha_11 ,
Thanks for reaching out to the Microsoft fabric community forum.
Currently, Power BI does not support customizing the refresh sequence of tables directly within the Power BI service. However, there are some workarounds that you can consider to achieve a similar result:
1. Disable Parallel Loading: You can turn off the parallel loading of tables in Power BI Desktop. This allows tables to refresh one by one. To do this, go to File -> Options and settings -> Options -> Data Load, and turn off the option "Enable parallel loading of tables".
2. Reorder Queries: In the Power BI Query Editor, you can reorder your queries by dragging and dropping them in the list. This can influence the order in which tables are refreshed. After turning off parallel loading, the tables should refresh in the order they appear in the query list.
3. Use Incremental Refresh
Incremental Refresh is designed to refresh only parts of the data (such as recent data or partitions) instead of refreshing the entire table. By setting up incremental refresh for the two tables you want to prioritize, you can ensure that only these tables (or their data partitions) get refreshed first and faster, without waiting for the other tables.
This method doesn't guarantee the precise order of refresh for all tables, but it can help by reducing the load on other tables and speeding up the refresh for critical ones.
How to set up incremental refresh:
In Power BI Desktop, go to the "Modeling" tab and select the table to configure incremental refresh.
Set the "Incremental Refresh" option and define the range of data that will be refreshed incrementally.
Publish the report to Power BI Service.
4. Split Tables into Separate Datasets
Another way to control refresh order is by separating your critical tables into different datasets. You can create separate Power BI datasets where each dataset refreshes at different intervals or with a prioritized refresh order.
Once you've split the tables, you can trigger the refreshes manually or schedule them at different times.
5. Use Power Automate (Flows)
If you're looking for more control over the refresh process, you can use Power Automate to set up a flow that triggers dataset refreshes in a specific order. You can first trigger the refresh of the critical tables' datasets and then the rest of the datasets.
Power Automate can call Power BI APIs to trigger dataset refreshes, so you can create a flow that specifies the refresh order for your datasets or tables.
Steps to use Power Automate:
Create a flow in Power Automate.
Use the Power BI connector to trigger the refresh of specific datasets.
Set up the flow to refresh one dataset before another, ensuring the priority order.
6. Managing Dependencies
You can also manage the dependencies between tables in the data model itself. For example, if Table A depends on Table B, then refresh Table B first to ensure the data model refreshes in the correct order. However, this doesn't explicitly control the refresh order—it helps ensure data dependencies are respected during the refresh process.
Please refer Microsoft official document and Community threads.
https://community.fabric.microsoft.com/t5/Desktop/SET-SOME-TABLE-NOT-TO-REFRESH/m-p/4113918
https://community.fabric.microsoft.com/t5/Desktop/Customized-table-refresh-sequence/m-p/888813
https://techcommunity.microsoft.com/discussions/excelgeneral/is-there-a-way-to-control-refresh-all-d...
https://answers.microsoft.com/en-us/msoffice/forum/all/power-query-refresh-order/2403c692-65b9-431b-...
https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-include-in-report-refresh
https://answers.microsoft.com/en-us/msoffice/forum/all/power-query-refresh-order-queries-pivots/a6c1...
https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview
If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thanks and Regards
