Forum Discussion
Incremental Refresh: Process data out with Incremental Refresh period
Hi, I have a report set up with an Incremental Refresh looking back 21 days. Sometimes in my data, a Team Member will need to update a Dimension field that will be out with this 21 day period...
You can either force a full refresh, or you can refresh individual partitions via XMLA calls.
Keep in mind that Incremental Refresh expects immutable data. It is not designed for your scenario (which would require differential refresh)
Thanks lbendlin , that's exactly what I needed.
I can connect SSMS to the Power BI Service Workspace, find the Tables I want to refresh and use SSMS to process the full table, overriding the Incremental Refresh.
Trememdous!