Forum Discussion

devzpowell's avatar
devzpowell
Regular Visitor
9 years ago
Solved

How to track data changed through timeline?

For example,   I have an file_A.xlsx containing category, value and date columns. The data is published in PBI report for the month M.   For the month M+1, new data comes but user corrected a "va...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi devzpowell,

     

    From your description, you want to keep the old record about that "value" for the "category" from the month M before correction when you refresh the data, right?

     

    Personally, I would suggest you deal on data source side. In file_A.xlsx, duplicate a worksheet of the month M, then open another connection from Power BI desktop to get data from this new worksheet.

     

    Also you can try the method suggested by BhaveshPatel  and Steve_Wheeler : Save old and append updated data into an additional table.

     

    Best Regards,
    Qiuyun Yu

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi devzpowell,

 

From your description, you want to keep the old record about that "value" for the "category" from the month M before correction when you refresh the data, right?

 

Personally, I would suggest you deal on data source side. In file_A.xlsx, duplicate a worksheet of the month M, then open another connection from Power BI desktop to get data from this new worksheet.

 

Also you can try the method suggested by BhaveshPatel  and Steve_Wheeler : Save old and append updated data into an additional table.

 

Best Regards,
Qiuyun Yu