filtering query string in power bi desktop not working for sql server

[romidersaini1]

i have created a report in power bi desktop by connecting to local sql server and i have published the report on the

https://app.powerbi.com . how can i query this published report for col .

i want to query the report for table Products where ProductName='Chai'

i.e this is not working .

https://app.powerbi.com/groups/me/reports/7fd333f9-04c1-4464-a90a-c441f75d42cc/ReportSection?filter=... eq ‘Chai’

how can i make it work .

[dkay84_PowerBI]

Have you tried Chai with no quotes?

[romidersaini1]

i have tried it with and without quotes it not working

both of this not working the report is showing the whole data .

https://app.powerbi.com/groups/me/reports/1c5860a3-32c9-4373-8e80-cb3f78a25035/

ReportSection?filter=ActivityA/activity eq 'Payment'

https://app.powerbi.com/groups/me/reports/1c5860a3-32c9-4373-8e80-cb3f78a25035/

ReportSection?filter=ActivityA/activity eq Payment

[v-sihou-msft]

@romidersaini1

I haven't reproduced your issue. As I tested with SQL Server data source, filtering report with URL parameter works properly in both direct quert and import mode. Make sure your input correct Table/Field name, they are case sensitive.

Reference:
Filter a report using query string parameters in the URL

Regards,