Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Tranform data before importing

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

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

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

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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.

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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" 🙂