Forum Discussion
Power BI Report Builder Parameters Type mismatch error
This is most likely caused by the fact that multiple selections in parameters get passed as an array of values and the query engine expects a parameter to be passed as a string.
There are a couple of solutions to this, the simplest is using the PATHCONTAINS technique here:
https://prologika.com/ssrs-multivalue-parameters-in-dax/
But PATHCONTAINS is not the best for performance, the following solution involves more code, but produces faster queries:
This is most likely caused by the fact that multiple selections in parameters get passed as an array of values and the query engine expects a parameter to be passed as a string.
There are a couple of solutions to this, the simplest is using the PATHCONTAINS technique here:
https://prologika.com/ssrs-multivalue-parameters-in-dax/
But PATHCONTAINS is not the best for performance, the following solution involves more code, but produces faster queries:
Thank you! I modified the filter expression and added the PATHCONTAINS and this worked!
Hi,
how can i amend my query , i didn't know can anyone help me im facing the same Smartin4 issue with my parameters
