Compare Yesterday refreshed Power BI Dataset with today dataset

[Amir851]

Dear All,

I am trying to create a KPI where I can compare all my tables present in my Dataset, which was refreshed yesterday with the same table in my dataset with Today refreshed dataset. The scope of this is to ensure that we have proper and accurate data in my Dataset.

All the tables in my dataset have excel as its source and Data being entered in those excel manually. So I would like to avoid any data discrepancies due to human error.

If the resolution requires the use of any scripting language, pls let me know me also.

Thanks

Amir

[JirkaZ]

@Amir851 This would require a manual process to put the previous load's dataset to cold, disable load and then load the new one. Idealy you should keep the load date somewhere in the dataset for each load.

[Amir851]

Dear @JirkaZ ,

Thank you for your replay..

if possible, Can you please show me a demo with some screenshot.

Thanks