Incremental Refresh - Excel files in SharePoint Folder - Is it possible?

[adelmonte]

Hi all,
Did anyone successfully implement Incremental Refresh with Excel or CSV Files on Sharepoint Folder?
Please don't send me links if you haven't implemented it yourself.
Thanks in advance.
Alex

[v-stephen-msft]

Hi @adelmonte ,

You can set incremental refresh for the report which get data from folder.

You may refer to this blog: Incremental refresh for files in a Folder or SharePoint – Power BI

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Incremental Refresh with Slow-Changing Source Data - Microsoft Power BI Community

[adelmonte]

Thanks but I get an issue with your solution.
"Expression.Error: The name 'GetFile' wasn't recognized. Make sure it's spelled correctly."

[lbendlin]

That's a convenience function to only pull specific columns from my excel files.  Modify as needed for your situation.

[adelmonte]

Thanks but I am a newbie how should I implement that function that gets my excel files content?

[lbendlin]

You don't need to use the function. Open the excel file in the original code instead.

If you like more help please provide sanitized sample data that fully covers your issue. Use one of the web file services. Please show the expected outcome.