Forum Discussion

JoyH's avatar
JoyH
Icon for Helper I rankHelper I
4 years ago

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...
Need Help
V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
4 years ago

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