Forum Discussion
Refresh only new data in sharepoint
Hi Jidapa18
Might not possible without incremental refresh. Power BI will reprocess all files in a SharePoint folder on each refresh when configured with Schedule refresh in Power BI Service.
You can use Power Automate flow to trigger as and when new data is getting added.
https://powerbi.microsoft.com/en-us/blog/refresh-your-power-bi-dataset-using-microsoft-flow/
3 Replies
Hi Jidapa18
Might not possible without incremental refresh. Power BI will reprocess all files in a SharePoint folder on each refresh when configured with Schedule refresh in Power BI Service.
You can use Power Automate flow to trigger as and when new data is getting added.
https://powerbi.microsoft.com/en-us/blog/refresh-your-power-bi-dataset-using-microsoft-flow/
Jidapa18 No, not natively. Use Power Query to track new files via timestamps/filenames.
I will below 2 steps for these requirement.- Helper Table: Stores processed filenames/dates (e.g., in SharePoint Excel). Power BI skips logged files.
- Power Automate: Triggers on new files → updates a parameter/log table → refreshes Power BI.
- In Power Query, add a parameter (e.g., LastLoadDate)
- Filter files using Date modified > LastLoadDate
- Manually update the parameter after each refresh*
Try above mentioned method to try.
Incremental refresh with excel is not supported for now.
Thanks
Harish M
Give kudos if I solve your problem. Accept this as solution.
I think the core is…PBI re-builds the SP file‑map every refresh, so it can’t pick only new files; u just move the old ones out first, and if that still breaks, split the folder small so the scan stays light.
