Forum Discussion

duamwalker's avatar
duamwalker
New Member
8 years ago

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 on...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

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 Gu

Sowjanya1's avatar
Sowjanya1
Frequent Visitor
8 years ago

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.