Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello, I have a table in power bi and I would like to know how to get the fields list of this table and export it to excel
Regards,
Solved! Go to Solution.
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
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!