Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Quickly Filter Out Salesforce Object Fields

I have recently connected to Salesforce Object, however my opportunity or account object consist alot of fields. Is there a way to quickly filter out the object fields without writing any advance edi...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    8 years ago

    Anonymous,

    In Query Editor of Power BI Desktop, you can use "Choose Column" option to select the columns that you want to reserve.


    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

The easiest way is to use the choose columns interface/remove other columns as this allows you to search for the columns you want easier than removing one by one.

 

Also if you include this at the start of your query, some query folding does happen in some cases but I havent worked out enough to say for sure what causes it.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago
    Hi Thomas can you show with a screenshot how do I filter out ?
    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Anonymous,

      In Query Editor of Power BI Desktop, you can use "Choose Column" option to select the columns that you want to reserve.


      Regards,
      Lydia

      • ollieT's avatar
        ollieT
        New Member
        2 years ago

        would the hidden columns still be part of the refresh or will it save 'space' and not have them synchronize into the pbix file?

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Anonymous,

     

    Can you share a screenshot on how you select and search the object field ?