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!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.