topic Re: URL Parameters (Boolean) in Report Server

URL Parameters (Boolean)

dkr — Tue, 11 Dec 2018 13:07:00 GMT

What is the SYNTAX for passing a boolean (True/False) filter via the URL?

I have tried

eq TRUE

eq 'TRUE'

eq -1

eq 1

Many thanks

v-qiuyu-msft — Thu, 27 Dec 2018 09:03:53 GMT

I guess you mean the parameter in rdl. You can pass this parameter: &ReportParameter1=true

Best Regards,
Qiuyun Yu

dkr — Mon, 07 Jan 2019 11:04:03 GMT

Thanks for your reply.

Unnfortunately this does not work on a PowerBI Dashboard

v-qiuyu-msft — Wed, 09 Jan 2019 09:07:10 GMT

For Power BI reports, fields type needs to be number, datetime, or string, see: https://docs.microsoft.com/en-us/power-bi/service-url-filters#field-types

Best Regards,
Qiuyun Yu