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 am trying to export "summarized data" from a table in .xlsx format.
In the exported excel file, one column name is showing "Table_Name[Column_Name]" instead of the column name defined. Although, I tried to export the other tables but the columns name of those tables are same as expected.
Does anybody know why the column name is exporting as "Table_Name[Column_Name]" and how to fix it ?
Any suggestion on this is really appreciated.
Best Regards,
Ankbaner
Solved! Go to Solution.
hi, @Anonymous
I have tested on my side, but not reproduce the issue.
For example:
Does that happen in other reports? If you try to republish this report?
And if possible, could you share this sample pbix file for us have a test?
Best Regards,
Lin
hi, @Anonymous
I have tested on my side, but not reproduce the issue.
For example:
Does that happen in other reports? If you try to republish this report?
And if possible, could you share this sample pbix file for us have a test?
Best Regards,
Lin
I cannot find any solution while navigating through the proposed solutions. Exporting Data with summarized option exports flat file of excel with column names as tablename[ColumnName]. Is this by default?
Thank you for your reply. There are some sensitive data due to which I cannot share the exact PBIx file. Therefore, I tried to reproduce the issue again and test the export to excel sheet from PBI service. The exported file contains the expected column name instead of “Table_Name[Column_Name]”.
Best Regards,
ankbaner
hi, @Anonymous
I suspect that it is a temporary issue, now it works well.
Anyhow It's pleasant that your problem has been solved, could you please mark the reply as Answered to close the thread?
Best Regards,
Lin
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.