cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Gdps Regular Visitor
Regular Visitor

Filter Problem

Hello all,

 

I get my data directly from Salesforce (objects).

 

Without making any changes in the Power Query Editor, I click "Close & Apply".

I have a total of 3671 rows. By filtering on the category I need, I get 904 rows.

 

But if I perform the same type of filter in the Power Query Editor and click "Close & Apply", I get only 56 rows.

I clicked "refresh" hoping to be a data update problem, but I continued with 56 rows.

 

Shouldn't the result be the same?

 

Best regards,

1 ACCEPTED SOLUTION

Accepted Solutions
Gdps Regular Visitor
Regular Visitor

Re: Filter Problem

I think I was using the filter the wrong way.

The data I needed to filter had 4 types of formats:

MO-xxxx
RD-xxxx
EW-xxxx
AD-xxxx

I needed to filter only the MO.

Then in Query Editor, in the search bar I would type "MO", and it would go back to reduced list.

But I saw that there is the Text Filters option. And by filtering MO through it, I got the exact value.

View solution in original post

3 REPLIES 3
JosefPrakljacic Established Member
Established Member

Re: Filter Problem

In the PowerQuery Editor only one preview/subset is loaded at a time.

 

If you click on Close&Apply - which number do you see there?

 

Because in principle you should see the same number of values.

 

BR,

Josef

 

Community Support Team
Community Support Team

Re: Filter Problem

@Gdps 

 

You may try adding Table.Buffer.

https://community.powerbi.com/t5/Desktop/Filtering-in-Power-Query-Editor-not-working-for-OData-sourc...

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Gdps Regular Visitor
Regular Visitor

Re: Filter Problem

I think I was using the filter the wrong way.

The data I needed to filter had 4 types of formats:

MO-xxxx
RD-xxxx
EW-xxxx
AD-xxxx

I needed to filter only the MO.

Then in Query Editor, in the search bar I would type "MO", and it would go back to reduced list.

But I saw that there is the Text Filters option. And by filtering MO through it, I got the exact value.

View solution in original post

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

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.

Users Online
Currently online: 358 members 3,343 guests
Please welcome our newest community members: