Forum Discussion
Power BI Dataset in Excel - Remove Table[Column] Prefix in Headers
Hi regerror6
Unfortunately, Power BI automatically adds the Table[Column] format when inserting a dataset into Excel, and there isn't a built-in way to remove it directly. However, you can manually rename the columns (not ideal for large datasets), use Power Query, or automate the process with VBA.
Let me know if you need guidance on these methods
If this solution was helpful, please accept it as a solution or give kudos to help other community members
Thanks for the insight, ArwaAldoud! Do you know of any way to import the dataset directly into Power Query (instead of landing it on a worksheet first)? I'm surprised Power BI is available in Excel (Data > Get Data > From Power Platform) but not in the New Source list in Power Query. I'm playing with Data Flows but hitting a dead end.
I would like to add that this is a very frustrating problem for me that is preventing me from using this feature.