How can I compare data of a report with its previous data?

[nafisa_111]

Let's take a case that I am having a table whose source is from SharePoint, we get new data every day after a refresh, but that data is add-on to previous data, to be more precise the previous data rows +new data rows = current data after refresh. Now after every refresh I want to check if the previous data is same after refresh also (because the source is updated manually so we don't want any mistakes). As of now I am doing it manually by storing the data previous data before refreshing, but I want to automate this process. This a PowerBI report so I need ways to automate this.

Quick solutions or responses are very much appreciated!!

Thanks

[v-yangliu-msft]

Hi  @nafisa_111 ,

This is the related document, you can view this content:

https://community.powerbi.com/t5/Desktop/Storing-and-using-information-from-a-dynamic-data-source-us...

https://community.powerbi.com/t5/Power-Query/Maintain-historical-Data/td-p/1135774

https://community.powerbi.com/t5/Desktop/store-historical-data-from-Power-BI-Online/m-p/127700

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Power BI has no memory. You need to do that in the upstream system.

[nafisa_111]

Thanks for response.Can you suggest me a way to do it using upstream??

[lbendlin]

Store your snapshots as separate CSV files on the SharePoint. Combine them in Power Query using the SharePoint.Files connector.