cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

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

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

Re: Quickly Filter Out Salesforce Object Fields

@Anonymous,

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
ThomasFoster Established Member
Established Member

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.

Anonymous
Not applicable

Re: Quickly Filter Out Salesforce Object Fields

Hi Thomas can you show with a screenshot how do I filter out ?
Anonymous
Not applicable

Re: Quickly Filter Out Salesforce Object Fields

Hi @ThomasFoster,

 

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

Moderator v-yuezhe-msft
Moderator

Re: Quickly Filter Out Salesforce Object Fields

@Anonymous,

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 320 members 3,081 guests
Please welcome our newest community members: