Forum Discussion
Solved
Refresh only new data in sharepoint
I have a folder in SharePoint that is used to load data into Power BI. When a new file is added to the folder, is it possible for Power BI to load only the newly added file while keeping the previous...
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.