Hi @Anonymous,
Based on my understanding, you want to get the list of all field names contained by a dataset table, right?
If so, you can achieve this in Query Editor mode.
Duplicate the source table, and apply all changes to the duplicated one. Select all fields at the same time, then, click "unpivot columns". Rename the new columns and remove unnecessary columns. And you need to remove the duplicates of field names.
You would get such a table.
In Power BI desktop, it is only supported to export visual data to CSV. You can add above data into a table visual, publish report to Power BI service, then, you could export summarized/underlying data into Excel or CSV file.
Best regards,
Yuliana Gu
Hi @Anonymous,
Based on my understanding, you want to get the list of all field names contained by a dataset table, right?
If so, you can achieve this in Query Editor mode.
Duplicate the source table, and apply all changes to the duplicated one. Select all fields at the same time, then, click "unpivot columns". Rename the new columns and remove unnecessary columns. And you need to remove the duplicates of field names.
You would get such a table.
In Power BI desktop, it is only supported to export visual data to CSV. You can add above data into a table visual, publish report to Power BI service, then, you could export summarized/underlying data into Excel or CSV file.
Best regards,
Yuliana Gu
Helpful resources
FabCon & SQLCon – Barcelona 2026
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Data Days 2026
Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
