Version history problem (Combining two online power BI datasets?)

[ConnorH]

Hi all,

I was trying to decide which forum section to post this in and was not 100% on if this would be a service related problem or Power query. My goal is to have a report that will give me changes in the data from each refresh. The data comes from sharepoint and I dont have access to any logs which i could use for version history. My thought process for a work around would be to have my main dataset (dataset1) and duplicate it (dataset2) and then combine these datasets. I could have an hourly refresh on dataset1 and a daily refresh on dataset2. Then I can find the differences between them and highlight them in a report. I am not sure if it is possible to have two online datasets and combine them or duplicate all tables within the dataset and set them on different refreshes though so I am looking for some advice.

[ponnusamy]

@ConnorH : What is the source from sharepoint? is it a file from sharepoint folder or list?

[ConnorH]

Online Sharepoint Lists