Changes in Data between Refresh

[GreenBoy]

Hi
I dont know if this is possible in Power Query or not, but i think its worth a try.

I access a database on a daily basis, most of the data doesn't change on a daily basis, but i need to be able to determine what has changed since i last logged in or last refreshed by PQ report.

The types of changes are new dates in fields, changes to existing dates, project status changes and obviously new items (deletions theoretically wont happen).

Any suggestions on how to do this without writing VBA would be gratefully received.

I suspect i am not the only person who has this issue, so there may already be a well documented solution.

Thanks
GreenBoy

 

[horseyride]

See http://www.excelandpowerbi.com/?p=237

 

[GreenBoy]

See http://www.excelandpowerbi.com/?p=237

Wow - this looks awesome - i will need some time to go through it.

Thanks Horseyride.

 

[horseyride]

When I do this type of thing myself, I usually just merge all the columns into one big column on both the new and old data sets then do a merge on that column from both data sets to remove matches. Whatever is left is a change/addition/deletion