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

       

      • 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