URL Filtering with field parameters

[mkavcic]

You can't access published report with URL filter when report uses field parameters.

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.

[v-xiaoyan-msft]

Hi @mkavcic ,

There are a couple of things to be aware of when using the query string parameters.

• When using the in operator, the values to the right of in must be a comma-separated list enclosed in parentheses.
• Power BI Report Server also supports the ability to specify more than one filter using the “filter” URL parameter. Here's an example of what the URL might look like in Power BI Report Server: https://reportserver/reports/powerbi/Store Sales?rs:Embed=true&filter= Store/Territory eq 'NC' and Store/Chain eq 'Fashions Direct'
• Report URL filters have a 10-expression limit (10 filters connected by AND).
• The long data type is (2^53-1) due to JavaScript limitations.
• Power BI doesn't limit the number of characters in URL query strings. Different browsers have different length restrictions.
• You can't filter on table or column names that start with the capital letters INF, including, for example, a table name starting with "INFORMATION". Upper-case INF is a special value in OData. If you want to start a table or column name with "INF", make it lower-case "inf" instead.

Embedding scenarios

URL filters are supported in some embedding scenarios and not in others.

• Embedding a report in a secure portal or website is supported.
• URL filters are supported in Power BI Embedded. See Power BI Embedded advanced URL filtering capabilities for details.
• Query string filtering doesn't work with Publish to web or Export to PDF.
• Embed with report web part in SharePoint Online doesn't support URL filters.
• Teams doesn't allow specifying a URL.

Best Regards,
Community Support Team _ Caitlyn

[mkavcic]

Hi Caitlyn (@v-xiaoyan-msft)

Thank you for your response.

The example you have provided

Server: https://reportserver/reports/powerbi/Store Sales?rs:Embed=true&filter= Store/Territory eq 'NC'

would be changed when using field parameters to something like

Server: https://reportserver/reports/powerbi/Store Sales?rs:Embed=true&filter= Store/Territory eq 'NC'[Territory]

but it does not work.

Also using double single quotes like the example in documentation does not work:

?filter=Table/Name eq 'O''Brien' 

so this would then become

Server: https://reportserver/reports/powerbi/Store Sales?rs:Embed=true&filter= Store/Territory eq ''NC''[Territory]

I also tried with unicode characters for brackets

Server: https://reportserver/reports/powerbi/Store Sales?rs:Embed=true&filter= Store/Territory eq ''NC''x005B_Territory_x005D

and in single quotes

Server: https://reportserver/reports/powerbi/Store Sales?rs:Embed=true&filter= Store/Territory eq 'NC'x005B_Territory_x005D

Nothing worked.

Again, thank you for looking into it.

Best regards,

Mitja

[jensbille]

I have used the URL filtering as descripped her: Filter a report using query string parameters in the URL - Power BI | Microsoft Learn for some integration, but if the table name has more than one space in the name it do not work.
Any tips? or is that a known issue?
Br Jens