Forum Discussion
change detection in archive data in incremental refresh.
In my fact table noticed that certain archive data got changed in the year 2018 . Table is set to incremental refresh. Is there any way to refresh only 2018 year data.
Anonymous , if change detection missed it because of date, and you are a premium customer, you can use XMLA endpoint and ssms and refresh the table partition
Power BI Premium - XMLA Endpoint - Data Refresh using SQL Server Management Studio: https://youtu.be/kyCnnpjOwpI
Using XMLA endpoints to change data sources in a Power BI dataset
https://powerbi.microsoft.com/en-us/blog/using-xmla-endpoints-to-change-data-sources-in-a-power-bi-dataset/
1 Reply
- amitchandak
Super User
Anonymous , if change detection missed it because of date, and you are a premium customer, you can use XMLA endpoint and ssms and refresh the table partition
Power BI Premium - XMLA Endpoint - Data Refresh using SQL Server Management Studio: https://youtu.be/kyCnnpjOwpI
Using XMLA endpoints to change data sources in a Power BI dataset
https://powerbi.microsoft.com/en-us/blog/using-xmla-endpoints-to-change-data-sources-in-a-power-bi-dataset/