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
Super UserHi 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.
- ArwaAldoud
You're welcome regerror6
Unfortunately, importing a Power BI dataset directly into Power Query without first landing it in a worksheet isn’t natively supported. However, if you have a Fabric (Power BI) license, specifically Premium or PPU, you can use XMLA endpoints to connect directly to the dataset.
Another option is using Dataflows, but if you're hitting a dead end, you might also explore Analyze in Excel.
If this solution was helpful, please accept it as a solution or give kudos to help other community members 
I would like to add that this is a very frustrating problem for me that is preventing me from using this feature.
