Filter condition in Dataflow not translating to Desktop

[ysherriff]

Hi all,

When I set a filter condition in Power Query dataflow, it is not translating when I refresh in Power BI Desktop. Can anyone direct me to why this could be the case?

Image#1 is the filter in query edtior in dataflow

 

Image #2 is in Power BI desktop where I still see the rows that are supposed to be filtered.

 

[v-binbinyu-msft]

Hi @ysherriff ,

Please try below steps:
1. Please confirm you set the filter rule in Dataflow edit pane correctly

2. Please try to connect this Dataflow again

3.Please try to create a new Dataflow and connect to it in Power BI Desktop

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ysherriff · Accepted solution]

Thanks. The issue is that I had an "Marketing Contacts" in the filter but it in the table it is "Marketing Contact".😂