Hi
I don't know if this is possible in Power Query or not, but i think its worth a try asking.
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
Dave
Hi Dave,
It's not really something you could completely automate with Power Query, but you could certainly use it. For example; write a query that gets the data from Access. Duplicate the query, then break the link to the source in the first query so it cannot refresh.
Compare the two queries using a the method described here.
You'd have to repeat this process each week so you had a snapshot of the data as at a point in time and then the latest version of the data.
Hope that points you in the right direction.
Mynda
Hi Mynda
Thank you for the reply - this is a really good solution - I can manage to copy all data from one table to another at time of workbook close and then run the comparison showing the changes from one to the other.
Thank you, this is going to be very useful.
David
