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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
oscar_bolanos
Advocate I
Advocate I

Filter a report using query string parameters (for instance "(blank)" values ) in the URL

Within Power BI Service, I am trying to filter only (Blank) values.

 

 

For instance, If I want to filter "Unit 1", the syntaxis would be: URL?filter=Table/Org eq 'Unit 1' and that's okay.

oscar_bolanos_0-1626894826594.png

However, I want to filter the (Blank) value (meaning NULL values), I tried with URL?filter=Table/Org eq '(Blank)' but Power BI interprets "(Blank)" as a string not as NULL.

 

What I need to get is an expression like: where Org is null or where lenght(Org) = 0.

 

I have already reviewed the documentation Filter a report using query string parameters in the URL - Power BI | Microsoft Docs

 

Are there any thoughts or ideas to workaround this issue?

 

2 REPLIES 2
Joanbo
Regular Visitor

Hello guys, I am having the same issue and I have looked everywhere, but have not found a way to make the odata URL filter understand blank Power BI values. Did you guy make any advance? 

I reached the same conclusion provided by @lbendlin , but with high cardinality models it is not a viable solution.

 

Thank you so much.

 

Tried URL filters                                 Worked

eq 'blank'no
eq blankno
eq nullno
eq 'null'no
(table/column eq null)no
(table/column eq blank)no
(table/column eq '(En blanco)')no
eq '(En blanco)'no
eq ''no
table/(column eq null)no
table/(column eq 'null')no
table/(column eq '')no

 

lbendlin
Super User
Super User

Excellent question. The only thing that comes to mind is using the "NOT IN ( )" approach (by "and"ing a couple of "ne"s) but that probably gets old quickly if you have high cardinality.

 

Filter a report using query string parameters in the URL - Power BI | Microsoft Docs

 

I think this should be raised as an idea.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors