Paginated Report with parameter True/False

[Anonymous]

Hello Community,

         I am building a paginated report with Power BI dataset as Source. I am trying to add a parameter of type "Boolean". When I added this parameter, and run the report, it is giving me an error i.e., Function 'CONTAINSROW' does not support comparing values of type Text with values of type True/False. Consider using the VALUE or FORMAT function to convert one of the values. 

Error Message

I don't see any CONTAINSROW function in my query. Below is the screenshot of query 

Can anybody help me with fixing the issue to add boolean datatype as parameter.

Below is the link to rdl file and pbix dataset

https://1drv.ms/u/s!AlTyyZ_9D_Wji1R3O3yougWplyrQ?e=ztyoVi 

Thanks

[v-easonf-msft]

Hi , @Anonymous 

Have you check the  Data Type of your Parameter?

I don't have much experience in SSRS. You can also post your question on sql-server-reporting-services forum  for professional help.

Best Regards,
Community Support Team _ Eason

[Anonymous]

Can anybody help me on this issue?

[v-easonf-msft]

Hi, @Anonymous 

Could you please tell me whether your problem has been solved?
If yes, you could accept the helpful answer as solution. You also could share your own solution here. For now, there is no content of description in the thread. If you still need help, please share more details to us.

Best Regards,
Community Support Team _ Eason

[Anonymous]

@v-easonf-msft I did try using Boolean as a data type, it still gave me the same error.

As an interim solution, I changed the data type of the field to "Text" in Power bi dataset.