Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now

mkavcic

URL Filtering with field parameters

Submitted by on ‎09-13-2022 12:06 AM

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.

Status: Investigating
See more ideas labeled with:
3 Comments (3 New)
Comments
Anonymous
Not applicable
‎09-13-2022 06:59 PM

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.

 

Best Regards,
Community Support Team _ Caitlyn

mkavcic
Frequent Visitor
‎09-14-2022 12:27 AM

Hi Caitlyn (@Anonymous)

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
Frequent Visitor
‎08-31-2023 05:32 AM

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 

Idea Statuses