Forum Discussion
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. ...
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 blank | no |
| eq null | no |
| 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 |