Forum Discussion
User-Editable task status in Power BI
If this is the case then the below video will be useful to you, this will help you keep one file[original file] as primary data source in power bi and make a copy of updated data within Power BI using Power Automate and save it elsewhere, Then you can merge original data and updated data.
https://www.youtube.com/watch?v=shc1SpXYrKo
Let me know if this helps and if you have any questions.
If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!
Ok, so if I get this correctly the PBI Excel and original excel get merged in PBI to always have the refreshed data.
Because the original Excel changes each day (new rows get added and some even removed) - this one is my primary data source, the PBI would just need to add additional field -> could I ascribe and then use unique row ID for this purpose?
If this is the case then the below video will be useful to you, this will help you keep one file[original file] as primary data source in power bi and make a copy of updated data within Power BI using Power Automate and save it elsewhere, Then you can merge original data and updated data.
https://www.youtube.com/watch?v=shc1SpXYrKo
Let me know if this helps and if you have any questions.
If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!