Forum Discussion
How to remove the table name and square bracket from the export file with live connections
Hi - I have some export files (live connections) from Power BI report but there're the table name and square brackets for all the columns in the export files as marked in RED below, is there anyone knowing how to set for removing them by default? Thank you.
Regards,
Watson LIAO
4 Replies
Hi,
Probably no option unless you transform the data again in power query.
The export process for live connections and Analyze in Excel uses DAX queries to retrieve the data, and DAX queries always return field names in fully qualified form (Table[Column]). There is no property or API parameter documented that changes that naming behaviour.
Thanks Mason for your quick response and I have already use PQ to transform the data, it seems there's the only way to make this happen. Hopefully Microsoft PBI team can improve this in the future. Have a nice day!
Hi Watson_LIAO.,
If this feature is important for your scenario, please raise it in the Ideas Forum. If it receives enough community votes, Microsoft may consider adding it in a future release.
Fabric Ideas - Microsoft Fabric Community
Thank you.
Noted and thanks!
