Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I'm building a paginated report on Power BI Report builder using an SSAS cube as my data source. I'm having issues with some of my parameters. If I select ALL or just one value I don't get an error, but when I select two or more values it throws me the following error:
The following system error occurred: Type mismatch.
----------------------------
Query execution failed for dataset 'TransactionsX'.
----------------------------
An error has occurred during report processing.
----------------------------
An error occurred during local report processing.
Has anyone else experienced this issue? I've been looking all over the place and I can't find a solution.
Thank you,
Solved! Go to Solution.
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:
Hi,
how can i amend my query , i didn't know https://www.rapidtables.com/tools/notepad.html
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:
Hi,
how can i amend my query , i didn't know can anyone help me im facing the same Smartin4 issue with my parameters
Thank you! I modified the filter expression and added the PATHCONTAINS and this worked!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
4 | |
4 | |
3 | |
3 |
User | Count |
---|---|
14 | |
9 | |
6 | |
3 | |
3 |