Power BI incremental refresh, need to change the column

[mr_data_man1]

I have a report that has a semantic model that is set to incremental refresh based on Inserted_date and now I need to changed the incremental refresh column to Updated_date.

My question is:
Now that I have this column Updated_date on the same table where (inserted_date) is, to changed the incremental refresh column, is it just as simple as: Right click the table name on the data panel, Incremental Refresh, and the chosing the new column?

p.s I will not be publishing the report, rather i will be pushing the changes thorugh vscode + git as the report is a .pbip  file.

Also I do have the parameters RangeStart and RangeEnd and everything was configured before so it works with the inserted date column now I just need to switch it to the updated refresh and test the full incremental load.


Looking forward for replies.

[Anonymous]

Hi @mr_data_man1 ,

If you change the incremental refresh policy, when you refresh the semantic model in service, it will recreate the partitions and import the data.

If your semantic model is stored in a premium capacity, you can also use the xmla endpoint to connect to your semantic model. After establishing the connection, you can manually recreate partitions, import data, calculate tables, etc.

https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-xmla

https://learn.microsoft.com/en-us/analysis-services/tmsl/refresh-command-tmsl?view=power-bi-premium-...

Best Regards,

Wearsky

[amitchandak]

@mr_data_man1 , It should reload the data to create a partition based on the updated date. Based on what I got.

[mr_data_man1]

Too add to my question.
In the desktop version I have the RangeStart = 1/12/2023, and RangeEnd=31/1/2024 (in order to not take to long to load the data in my dektop version) while in PowerBI service such limitation isn't set. If I push the changes will it be changing the StartRange and EndRange as well?

So after I push the changes to power bi service do I need to run a refresh for there as well and the data will be loaded again?