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
Join our Fabric User Panel
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
| User | Count |
|---|---|
| 63 | |
| 62 | |
| 42 | |
| 19 | |
| 16 |
