Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Hi @jm_brenot,
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
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
Hi @jm_brenot,
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