Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
PBIAnonUser
Frequent Visitor

On-Premise Report Server URL not working

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.

1 ACCEPTED SOLUTION
v-henryk-mstf
Community Support
Community Support

Hi @PBIAnonUser ,

 

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

URL?filter=Table/Field eq 'value'

vhenrykmstf_0-1662368423155.png

 

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.

View solution in original post

2 REPLIES 2
v-henryk-mstf
Community Support
Community Support

Hi @PBIAnonUser ,

 

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

URL?filter=Table/Field eq 'value'

vhenrykmstf_0-1662368423155.png

 

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.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors