Forum Discussion

DocDri's avatar
DocDri
Icon for Helper I rankHelper I
1 year ago
Solved

Filter 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   ...
Need Help
  • DocDri's avatar
    DocDri
    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'

Cookistador's avatar
Cookistador
Icon for Super User rankSuper User
1 year ago

Just to clarify, 

 

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

And what is the type of Order Number ?

Cookistador's avatar
Cookistador
Icon for Super User rankSuper User
1 year ago

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