Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
ysherriff
Resolver II
Resolver II

Filter 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 dataflowysherriff_2-1667142161695.png

 

 

 

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

 ysherriff_3-1667142169035.png
1 ACCEPTED SOLUTION

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

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

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.

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!