Forum Discussion
Helper IFilter via Power-BI URL does not work
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'
Helper IThanks, 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.
Super UserJust to clarify,
Is it working with other fields from the table MMM_GGG: Table000 ?
And what is the type of Order Number ?
- DocDri
Also doesn't work with other fields from that table. Order number is from type text.
- 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