Forum Discussion
Power BI Incremental Refresh
Hi. I have souce from on prem sql and source from excel file in sharepoint and when publishing to service gateway is approved for SQL. I also have an MS Flow that refreshes power bi dataset ever...
Hi
Thank you, will this be incremental refresh or power query setting on filtering the rows? and if I can dynamically pull the rows will historic data remain and only latest gets refresh or new rows added?
Thanks
Hi Anonymous,
in my view, it's an incremental refresh that you need to set up through Power Query Filter.
The historical data remain and only the defined refresh range is updated.
https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh
I wrote a blog post on a similar topic.
https://community.powerbi.com/t5/Community-Blog/Incremental-Refresh-with-Subqueries/ba-p/1003337