Forum Discussion
Adding commentary column to linked dataflow table in Excel and not erasing after refresh
Hi eanderson614 ,
To preserve your commentary during data refreshes in Excel, you could try:
Create a separate table for your commentary.
Use Power Query to merge this commentary table with your main data table based on a unique identifier.
Load the merged data back into Excel.
This way, your commentary will remain intact even after refreshing the data from the Power BI dataflow.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for your reply. I have tried this but the issue I have is the commentary table will constantly have new customers added to it. So I would have to make sure all customers are on the commentary table constantly which is a lot of manual effort. Any thoughts on this?