Forum Discussion
Helper IFilter via Power-BI URL does not work
Hello,
I want to filter a report via URL. That worked well for me with several fields, but with one I have a problem:
The Table name is MMM_GGG: Table000
The field name is: Order Number
In the URL i used: ?filter=MMM_GGG:_x0020_Table000/Order_x0020_Number eq '123AB'
What's wrong? is the underline in the table name the problem?
Thanks for any hint!
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'
8 Replies
- Cookistador
Super User
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
DocDriThanks, 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.
- Cookistador
Just to clarify,
Is it working with other fields from the table MMM_GGG: Table000 ?
And what is the type of Order Number ?
- grazitti_sapna
Hi DocDri
Can you please try the below syntax:
?filter=MMM_GGG_Table000/Order_x0020_Number eq '123AB'
🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!- DocDri
Thanks, but that doesn't work.
- DocDri
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'
