Forum Discussion
Power Query Filter doesnt works
Hello, I have a strange Problem and I Hope anyone can help:
I imported some data from a odata source (sap data via theobald). In PowerQuery I've added a filter on a column. The filter was applied and shown in the M Code. But the Filter does not have any affected on the preview data and does not any changes in the data model ( dax). The filter does not work! The filter is very easy, I've only selected some elements in a list.
On the next step I've created a calculated column and checked via M if the value does meet the filter requirements and put into the column a 1, if not, a 0. Next I filter the column to the value 1 and it works.
I think powerbi does push the filter against the odata source and this step doesn't works?
Today I've try to monitor the dataflow via Fiddler.
If I import data via ODATA and filter it via M, the filter will be pushed to the REST service:
So I think the ODATA service by the customer has some problems.
8 Replies
you are importing the data as in shown here right?
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-connect-odata/
If you do that the data is loaded to your PBI Desktop and should be able to be filtered locally.
Maybe you can give some more details on where you put the filter and how your data looks like you want to filter?
Hi Anonymous,
After add filter in Power Query, have you click the "Apply" button?
And I personally suggest you get data from other resouce(Eg,Excel) and add filter in same step, and check if it works fine.
Best Regards,
Angelia
