Forum Discussion
Refreshing just one column.
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
You can use incremental refresh this will ensure your old data is in the memory and only last few days or week is being refreshed as needed -https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview.
Or you can setup a code with Power query or Power automate as well. If you need idea around these then you might have to explain your setup like; what is the source and how is the structure, I believe if it's csv files then you might be keeping it in SharePoint or a folder, so what files you have and do you append within the files or drop new files in the folder?
Thanks for your reply Ankut. Every week when cost centers send results to a SP folder the previous week file is replaced with current week's file . So issue is some times within this current week file, results for previous week is altered. Incremental refresh will not work because files are not appended or added rather replaced with a new file.
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 ,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.
