Tranform data before importing

[Anonymous]

How do I import only the columns I need from an object in Salesforce to PowerBI?

[Anonymous]

I was able to select columns I want by using "Table.SelectColumns(New table name,{"col1", "col2"})".

I also found there is an button to "Choose columns" 🙂

[Anonymous]

Can I use Table.SelectColumns{} and specify the columns in Edit Query window?

[Greg_Deckler · Accepted solution]

In the Query Editor, select the columns that you want, right-click and then Remove Other columns.

[Anonymous]

If you use the SF connector, you have to import all the columns and then in powerquery remove the columns that you don't need.