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?
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.
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!!!