New Enterprise DNA Initiatives

List of columns in data flow table

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?

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.

@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

Thank you both!!!

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!