change detection in archive data in incremental refresh.

[Anonymous]

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.

[amitchandak · Accepted solution]

@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/