Forum Discussion
Solved
Refreshing just one column.
Hi all, I have weekly 100 CSV files consolidated as below for a dashboard every week, this table is refreshed with new weeks Data. Issue: Sometime previous week's data is changed at source ...
Hi mwm39 ,
Thanks for your clarification. Incremental refresh will not work here since the files are being replaced, not appended. Incremental refresh requires additive rows with a stable date column.(docs).Try These Workarounds :
Archive each weekly file with a timestamp (e.g., via Power Automate) so history is preserved.
Use a self referencing merge in Power Query to retain past data while refreshing only the current week.
Store data in a staging location (SQL/SharePoint/Dataverse) that accumulates weekly snapshots for Power BI.
Microsoft Docs :
Incremental refresh in Power BI
Hi! mwm39
Then you need a small indentifier in your file like a week column and then you can create a simple Power Automate flow to keep your data.
-
- Read the file.
- Extract only current week’s data.
- Update Table in a Excel file, replacing only current week’s rows.