Filter via Power-BI URL does not work

[DocDri]

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!

[DocDri · Accepted solution]

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'

[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. 

[Cookistador]

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

[DocDri]

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. 

[Cookistador]

Just to clarify, 

Is it working with other fields from the table MMM_GGG: Table000 ?

And what is the type of Order Number ?

[Cookistador]

Ok, so the issue is comming from your table

Maybe, there is something wrong with the internal name of the table, can you try to follow this step with tabular ediot 2? 

The most reliable way with internal model Browse is via external tools:

• Install Tabular Editor (free version).
• In Power BI Desktop, go to the External Tools tab.
• Click on Tabular Editor.
• In Tabular Editor, expand "Tables".
• Find your table MMM_GGG: Table000. Select it.
• On the right, in the "Properties" pane, look for the Name property under "Basic" (this is the internal model name). This is the name you should use in the URL filter. It might be different from the display name, e.g., Table000 or MMM_GGG_Table000 if Power BI stripped the colon or space.
• Similarly, expand the columns of that table and find Order Number. Check its Name property.

If you do not have right to install it, there is a portable version

[DocDri]

Also doesn't work with other fields from that table. Order number is from type text.