Forum Discussion

mwm39's avatar
mwm39
Frequent Visitor
11 months 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
    11 months 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

mwm39's avatar
mwm39
Frequent Visitor
11 months ago

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. 

v-sshirivolu's avatar
v-sshirivolu
Community Support
11 months 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

  • v-sshirivolu's avatar
    v-sshirivolu
    Community Support
    11 months ago

    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.

     

    • v-sshirivolu's avatar
      v-sshirivolu
      Community Support
      11 months ago

      Hi mwm39 ,
      I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you

       

      • v-sshirivolu's avatar
        v-sshirivolu
        Community Support
        11 months ago

        Hi mwm39 ,
        I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions