User Profile
JonathanR
New Member
Joined 1 year ago
User Widgets
Contributions
Re: Tracking changes to data when refreshing the data source
Hi Akash, Thankyou for your response. Would I need to use power automate to save each refresh into a table? Or can it all be done via power bi desktop/power query? If you could point me to any demo's or resources that would be amazing. Thanks.1.4KViews0likes1CommentTracking changes to data when refreshing the data source
Hi All, I have a dataset that is connected to a spreadsheet (via web link) and I plan to set up a weekly automatic refresh. The spreadsheet is where all the data is changed/new rows are created. The refresh functionality should be fairly straightforward, but I am trying to think of a way to track the historical datasets so that I can compare what has changed week on week (i.e., highlight any data/inputs that have changed in the current refresh, compared to the dataset a week prior). For context, it is CRM data, so I would like to track any new rows/leads that have been added to the dataset or any status changes that were made (i.e., the status of one lead went from 'potential' to 'likely', so the count of leads that were likely went from 8 to 9). Hopefully it makes sense. Thanks in advance.Solved1.5KViews0likes6Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.