Importing data into excel from Power Platform > Power BI adds query name into column

[threw001]

Hi guys,

I have a query in Power BI called Employees. Within this query I have a set of data that I would like to bring into an excel file and have a live direct link to the semantic model.

This works perfectly using the feature "Get Data" within the "Data" ribbon of Excel.

The process I am using is as follows

Excel > Data ribbon > Get Data > From Power Platform > From PowerBI. I then select the report and the table and pick the fields I would like to pull into Excel.

The issue I am having is that the Table Name is added into the column name so for example, the column "Employee Full Name" will be displayed as Employees [Employee Full Name]. It takes the table name first and then puts the column name in brackets.

Is there anyway to get rid of the table name and the brackets? I would like only the column name to come through.

If I was to manually over-ride the column heading, upon refreshing, it then pulls back the original column name in (which consists of Table Name [Column Name]).

Thanks so much!

[Anonymous]

Hi, @threw001 

Thanks for DataInsights's reply. In fact, the current version of EXCEL does not seem to support the ability to customize field names when importing data. You can use the Export Data feature in Power BI Service to export this data to .xlsx file.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[DataInsights]

@threw001,

You can use SELECTCOLUMNS to assign custom field names which prevents table names from displaying. Example:

SELECTCOLUMNS ( Employees, "Employee Name", Employees[Employee Name] )

I'm not aware of a way to remove field name brackets.