Forum Discussion
filter via URL query string not working
i have a report that pulls datasets from application insights requests table. i would like to filter this report for date values, however, i am aware that the "filter via URL query string" process only takes string values and i am wondering if there is a workaround for this?
The syntax seems to be ?filter=<table>/<column> eq 'string value to filter'
/* tried to filter on date first then decided to test string values which did not work either */
This seems to not work for me even after following the tutorial video and documentation even when i filter on an actual string value in the table.
Can someone help?
3 Replies
Hi duamwalker,
As mentioned in tutorial, URL query string can filter only string value. It doesn't apply to date fields.
You said URL query doesn't work when you filter on an actual string value in the table, could you please show me the sample data and the filtered URL?
Please be aware that:
- Table and field names cannot have any spaces
- Table and field names are case sensitive. The value is not.
- Fields that are hidden from report view can still be filtered
- Value has to be enclosed with single quotes
- URL query string doesn't work if publishing report to web
Regards,
Yuliana GuEven i got the same issue when filtering by using URL query in power BI report server,My table is like this [AB].[CD] and column which is a string value .e.g Description, and used below URL query to display the report
http://***********/Reports/powerbi/FilterPBI_DQ?filter=[AB].[CD]/Description eq 'Mango'
Please let me know what went wrong in the above query.
Even i got the same issue when filtering by using URL query in power BI report server,My table is like this [AB].[CD] and column which is a string value .e.g Description, and used below URL query to display the report
http://***********/Reports/powerbi/FilterPBI_DQ?filter=[AB].[CD]/Description eq 'Mango'
Please let me know what went wrong in the above query.
