Forum Discussion
Power Query Filter doesnt 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.
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?
Yes, I do it like this - here some Screens from Demo Data - in this example everything works fine:
In my productive envoirement the M Filter does not work. And I don't know why?
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,
AngeliaYes, of course!
Hi Anonymous,
Based on your screenshot above, could you please share a screenshot after you click "Ok"?
In addition, please save your .pbix file and restart it, check if it works fine.
Best Regards,
Angelia