DAX evaluate table : how to remove ‘table name’ from columns name

Hi,

I’m using this great post (https://biinsight.com/exporting-data-from-power-bi-desktop-to-excel-and-csv-part-2-importing-power-b…) to export table data from Power Bi directly to Excel.

Using EVALUATE ‘Table’ returns columns named TABLENAME[ColumnName].

Is there a way to get rid of the TABLENAME[] in each column name?

Thanks for your help.

Sincerely,

JM