Forum Discussion
Solved
External Data Properties
Hello, I'm connecting a Power BI dataset to an excel file to get a table such that users can go into the excel file and enter comments, which is a new column in the excel file and not a column in...
Did you try connecting the Excel table back to powerbi the way I described? This approach works fine within Excel itself.
The main concern with connecting Excel back to PBI is that you would need to immediately refresh the Excell anytime you refreshed the PowerBI. I understand this may not match your work-flow....
I agree that manually copying is error prone and confusing.
Hi darentengmfs
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
A key part of the problem is that the "Overwrite existing cells.." option won't stay selected. I'm having the same issue.
