Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
103 | |
76 | |
66 | |
63 |
User | Count |
---|---|
142 | |
105 | |
102 | |
81 | |
68 |