Forum Discussion
Incremental Refresh - historical data updates
Hi! One of our tables has 80M rows. Each row contains the insert_dtm (the datetime the row was created) and update_dtm (the datetime the row was last updated). During the incremental refresh, we n...
The open-source Tabular Editor 2 tool provides an easy way to bootstrap an initial refresh operation. After publishing a model with an incremental refresh policy defined for it from Power BI Desktop to the service, connect to the dataset by using the XMLA endpoint in Read/Write mode. Run Apply Refresh Policy on the incremental refresh table. With only the policy applied, partitions are created but no data is loaded into them. Then connect with SSMS to refresh the partitions sequentially or in batches to load and process the data. To learn more, see Incremental refresh in Tabular Editor docs.
See if this blog will help:
https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-xmla