Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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:
Regards,
Yuliana Gu
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
106 | |
86 | |
73 | |
66 |
User | Count |
---|---|
124 | |
113 | |
98 | |
81 | |
72 |