Forum Discussion
The CSV file exported from a Power BI table visualization cannot be used to create a pivot table
Thanks for the reply.
Good news — I’ve identified the root cause of the issue.
The original table visualization had a title of [Raw Data] Customer Information, and when exporting the data, this title was used as the file name. It turns out that the square brackets [] in the file name were causing Excel to:Fail to create a pivot table
Fail to save the file as .xlsx
Once I removed the square brackets from the visualization title (so the exported file name didn’t include them), everything worked as expected inlucdes create a pivot table in CSV file directly.
Hope this helps anyone facing the same issue!
Super UserHi Jeff_CC - PivotTables don't work on CSV files unless the data is fully converted into an Excel table or range.It treats the content as text data without formal table/range structure.
suggest:
Open the CSV file in Excel>>Go to File > Save As>>Choose Excel Workbook (.xlsx)>> Now insert a PivotTable—this will work as expected.
Hope this helps.
Thanks for the reply.
Good news — I’ve identified the root cause of the issue.
The original table visualization had a title of [Raw Data] Customer Information, and when exporting the data, this title was used as the file name. It turns out that the square brackets [] in the file name were causing Excel to:Fail to create a pivot table
Fail to save the file as .xlsx
Once I removed the square brackets from the visualization title (so the exported file name didn’t include them), everything worked as expected inlucdes create a pivot table in CSV file directly.
Hope this helps anyone facing the same issue!