Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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
Anonymous
Not applicable

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
Anonymous
Not applicable

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.

v-chuncz-msft
Community Support
Community Support

@Anonymous 

 

You may try adding Table.Buffer.

https://community.powerbi.com/t5/Desktop/Filtering-in-Power-Query-Editor-not-working-for-OData-source/m-p/691749#M333576

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.
JosefPrakljacic
Solution Sage
Solution Sage

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

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.