Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

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 a...
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
9 years ago

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?

 

 

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Yes, of course!

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Microsoft Employee
      9 years ago

      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago
        Ive Gott the issue only within the theobald odata Data (Please See at mal First Post die Mode details). If the Filter only on Client Side, I just Search on the Client for solutions. Thanks