Forum Discussion
External Data Properties
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
Thank you for reaching out microsoft fabric community forum.
Go to the External Data Properties dialog box in Excel. Under the "Preserve column sort/filter/layout" option, set to "Clear unused cells" or "Overwrite existing cells with new data" instead of using "insert entire rows for new data". This should help keep your "Comments" column aligned correctly.
Instead of directly connecting Excel to Power BI, use Power Query to refresh the data. This can give you more control over how the data is updated and aligned.
If you need any further assistance or have any questions, please feel free to reach us.
If this solution helps, please consider giving us Kudos and accepting it as the solution so that it may assist other members in the community.
Thank you.
Your solution doesn't work. Please read the question properly. I have the same issue with the OP. The settings don't properly work and always revert back.
