This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreDid you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now
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 April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 34 | |
| 31 | |
| 30 | |
| 21 | |
| 16 |
| User | Count |
|---|---|
| 62 | |
| 51 | |
| 31 | |
| 23 | |
| 23 |