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

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
rdg515
Resolver I
Resolver I

How to maintain Query folding with multiple filters using an OR operator

I want to filter the table results by checking if Column A > 0 or Column B > 0.  At this filter step, query folding breaks; I am using the right-click > View Native Query being grayed out as my indication.

 

If I just filter on Column A > 0 then query folding is working if I just did Column B > 0 it's also working, and if I did Column A > 0 AND Column B > 0 it works.

 

The issue seems to be with the OR condition.  I even tried adding a custom column true / false column using an if statement with the OR conditions but query folding broke on that step.

1 ACCEPTED SOLUTION
rdg515
Resolver I
Resolver I

Disregard, I'm an idiot, I removed Column B in a previous step Power Query didn't throw any warnings so I didn't realize that was happening until I applied.  OR condition works just fine.

View solution in original post

1 REPLY 1
rdg515
Resolver I
Resolver I

Disregard, I'm an idiot, I removed Column B in a previous step Power Query didn't throw any warnings so I didn't realize that was happening until I applied.  OR condition works just fine.

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.