On-Premise Report Server URL not working

[Anonymous]

Hi,

I'm trying to set a filter in a URL as follows: 

URL?filter=Table Name/ColumnName eq 'string' 

E.g. 

powerbireportserver/folder/test/report1?filter=Dimension One/ColumnOne eq 'example1'

but when I do so, nothing is filtered. I have the May 2022 version of Power BI desktop. 

The column name in SQL is called 'Dimensional.One' , and in Power BI, its 'Dimension One' (with no full-stop)

Have I got the syntax for the URL wrong? 

Thanks.

[v-henryk-mstf · Accepted solution]

Hi @Anonymous ,

Does it match the filter rule? Table and Field names are case-sensitive, value isn't.

URL?filter=Table/Field eq 'value'

For more details, you can read below document:

Filter a report using query string parameters in the URL - Power BI | Microsoft Docs

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , refer this part of the document

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters#special-characters-in-table-and-column-names