Reply
Highlighted
Member
Posts: 67
Registered: ‎11-21-2017
Accepted Solution

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 editior syntax ? 

The current way that I am doing is by manually removing the object one by one and it is very time consuming.

 

image.png


Accepted Solutions
Moderator
Posts: 8,904
Registered: ‎03-10-2016

Re: Quickly Filter Out Salesforce Object Fields

@BDA2,

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

Regards,
Lydia

View solution in original post


All Replies
Established Member
Posts: 147
Registered: ‎10-31-2017

Re: Quickly Filter Out Salesforce Object Fields

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.

Member
Posts: 67
Registered: ‎11-21-2017

Re: Quickly Filter Out Salesforce Object Fields

Hi Thomas can you show with a screenshot how do I filter out ?
Member
Posts: 67
Registered: ‎11-21-2017

Re: Quickly Filter Out Salesforce Object Fields

Hi @ThomasFoster,

 

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

Moderator
Posts: 8,904
Registered: ‎03-10-2016

Re: Quickly Filter Out Salesforce Object Fields

@BDA2,

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

Regards,
Lydia