Forum Discussion
Field parameters and URL filters
Hi,
I have published a report with field parameter on my dashboard.
I have been trying to reference a field parameter in URL with no success.
How could I use the &filter=Table/Fieldname eq 'Tablename'[Fieldname] ?
Thank you!
6 Replies
- AnonymousNot applicable
Hi mkavcic ,
Just use "_x0020_" instead of space in the table name, like this:
&filter=Table _x0020_ name.
Special characters in table and column names
Special characters and spaces in table and column names require more formatting. When your query contains spaces, dashes, or other non-ASCII characters, prefix those special characters with an escape code starting with an underscore and an X (_x), then the four-digit Unicode, then another underscore. If the Unicode is fewer than four characters, you need to pad it with zeroes. Here are some examples.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- mkavcicFrequent Visitor
Hi,
I am not using any space in table name.
My example was &filter=Table/Fieldname eq 'Tablename'[Fieldname]
So no empty spaces.
- mkavcicFrequent Visitor
Is there anybody that uses URL filtering with FIELD PARAMETERS?
I have searched everywhere and found no working solution.
I have tried all the custom formatting options and URL filtering does not work.
As far as I know, this is a bug.
- AnonymousNot applicable
Hi mkavcic ,
I have found a similar post, please refer to it to see if it helps you.
Solved: Power BI ignoring passed parameters in URL - Microsoft Power BI Community
- pass the filter parameter via $filter=Table/Field eq 'value
- pass the filter parameter by modifying URL like below:
- https://app.powerbi.com/reportEmbed?reportId=7860e7e8-4acf-4e94-a860-1af6d633ad57&autoAuth=true&ctid...&$filter=DimSalesTerritory/Group eq 'Asia'
- Embed a report in a secure portal or website - Power BI | Microsoft Docs
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- mkavcicFrequent Visitor
No working solution found.
I will be reporting an issue/bug.
- mkavcicFrequent Visitor
Accessing report with URL when using field parameters does not work.
I tried with URL of the report, that I copied from published report and added
&filter=Table/Fieldname eq 'Tablename'[Fieldname]
and it does not work.
It does work without field parameters.
Field parameters have composite key.
I have tried addressing each one of them but it does not work.
DAX studio works when filtering with field parameters, so I used the same logic in URL, but it does not work.