Forum Discussion
Filter via Power-BI URL does not work
- 1 year ago
I have the solution now. Colon (:) has to be coded with x003a_ and underscore (_) with _x005f_ so the correct url which works is:
?filter=MMM_x005f_GGG_x003a__x0020_Table000/Order_x0020_Number eq '123AB'
Hi DocDri
Can you try with the following url:
?filter=MMM_GGG%3A%20Table000/Order%20Number eq '123AB'
%3A is the URL encoding for a colon (:)
%20 is the URL encoding for a space
- DocDri1 year ago
Helper I
Thanks, but doesn't work. _x0020_ for space does also work for other fields I have, thats also what microsoft says (Filter a report using query string parameters in the URL - Power BI | Microsoft Learn). %3A for colon does not make a change.
- Cookistador1 year ago
Super User
Just to clarify,
Is it working with other fields from the table MMM_GGG: Table000 ?
And what is the type of Order Number ?
- DocDri1 year ago
Helper I
Also doesn't work with other fields from that table. Order number is from type text.