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

[Anonymous]

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

[v-danhe-msft]

Hi @Anonymous,

I have tested the evaluate function in Dax studio, you could use the formula to test if it could get column data:

EVALUATE 
	VALUES(Table1[Column1])

I hope it could help you.

Regards,

Daniel He

[Anonymous]

Thank you for your answer Daniel.

Unfortunately, from excel SSAS connection, using EVALUATE VALUES(Table1) still brings Table1[] around the names of the columns.

Reagards,

JM

[v-danhe-msft]

Hi @Anonymous,

Based on my test, it could work in the Power BI Desktop, you could refer to below picture:

Could you have tried the code EVALUATE VALUES( your table [your column]) instead of the code EVALUATE VALUES(your table)?

I suggest you try again.

Regards,

Daniel He