Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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...
Need Help
mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Hi,

you can apply the filter, it just won't be query folded to the source.

You do not get any speed advantage, but you can reduce the calls to AI text analytics to the new rows.

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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