Forum Discussion
Track changes from Excel to Power Bi
Hello,
here I have this problem.
I have an excel sheet with values that can change over the time.
When I refresh the excel sheet, the old values are overwritten and so I get them lost.
I was looking for a way to have a table with the old values stored.
What I would not do is to make this process manual, in other words I would like to keep track of changes automatically.
Not sure is power bi is the right tool to do this.
Thanks in advance for your answer.
Hi Mic1979
You can use a power automate for this goal.
Take a look at the linked tutorials:https://www.youtube.com/watch?v=8KyF-wMP0O4
https://www.youtube.com/watch?v=SOQeNnSwp60
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
3 Replies
- Ritaf1983Super User
Hi Mic1979
You can use a power automate for this goal.
Take a look at the linked tutorials:https://www.youtube.com/watch?v=8KyF-wMP0O4
https://www.youtube.com/watch?v=SOQeNnSwp60
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly