Forum Discussion

mwm39's avatar
mwm39
Frequent Visitor
1 year ago
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 ...
Need Help
  • v-sshirivolu's avatar
    v-sshirivolu
    1 year ago

    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

    Dataflows and incremental refresh

    Automate file management with Power Automate

Shahid12523's avatar
Shahid12523
Community Champion
1 year ago

Power BI always reloads everything → you can’t refresh only one column.

 

How to Fixes:

Reshape to long format (Cost Center | Week | Value) → enable Incremental Refresh so only recent weeks update.

Keep two tables → one frozen (old weeks, refresh off) + one live (latest weeks, refresh on) → then append.

Archive weekly CSVs in separate files/folders → append all to preserve history.

Best option: reshape to long format + use Incremental Refresh.