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 every 5minutes. My problem is  2 fold :

 

1. Incremental refresh -Issues around query folding

2. AI text Analytics reruns for entire dataset every time refresh is done.

 

How can I refresh only what was updated and AI text analytics only work with new rows added to the excel file and not the entire dataset? Based on my current set up I need a solution please or guidance towards one

Need Help

5 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi

       

      Yes, however can this be applied to an sharepoint excel file ? Will query folding be an issue?

       

      Thanks

      • 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.