Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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-bi-data-to-excel-directly) to export table data from Power Bi dir...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

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