List of columns in data flow table

Power BI Data Model
1

I am connected to a salesforce object which contains hundreds of fields. Is there a way to obtain a list of all the column names in this table using the Power Query Editor?

image
image720×793 46.4 KB

2

Hi @acnyc88,

Sure create a new blank query and enter this M code.

Table.ColumnNames( Account )

The result is a list with all column names from the Account query.

3

@acnyc88

Yes. You can get columns names using Table.ColumnNames().

It will give you output as list. You can convert list to table also.

Right click on the List and click on To Table

image
image1081×375 7.94 KB

4

Thank you both!!!

5

Hi @acnyc88, did the responses provided by @Melissa and @Rajesh help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark the thread as solved. Thanks!