Forum Discussion
Resolver IIFilter condition in Dataflow not translating to Desktop
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.
Thanks. The issue is that I had an "Marketing Contacts" in the filter but it in the table it is "Marketing Contact".😂
2 Replies
Hi ysherriff ,
Please try below steps:
1. Please confirm you set the filter rule in Dataflow edit pane correctly2. 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.
ysherriffThanks. The issue is that I had an "Marketing Contacts" in the filter but it in the table it is "Marketing Contact".😂
