Report logs of what was loaded

[tomas12344]

Hi All

I just wondering, if there is a way to do some logs for the report, what was loaded - how many rows, some details about input files,....
Have created for a customer a report, which loads some CSV files. It happend (and it starting to be to offten), that they prepare little different input file and than they complain, that it is not working....
Unfortunately, they have access to the CSV file, they dont want to handover to someone, who understand more about such changes in input files, and they dont want to implement any checking before loading the file. So it is always to spend hours of investigating, what was changed,...

Any idea, how to create any log table/file, maybe in power query? I know, that there are some metadata, but dont know about any details, what can be read from the metadata.

[v-junyant-msft]

Hi @tomas12344 ,

From my understanding, I think it is possible that your desired result is not achievable because PQ has no way of comparing what is different in the files used for the two refreshes and no way of detecting the changes that have taken place on the data source side.

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