Forum Discussion
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.
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.
2 Replies
- amitchandak
Super User
Anonymous , refer this part of the document
v-henryk-mstfCommunity Support
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.
