Forum Discussion
Apply Parameter
I am using an Analysis Services database and I intend to only return data for a given year.
For this, I am using the following syntax ...
{Cube.ApplyParameter, "[DimensioName]. [Column]. [Column]", {"2021"}}
But when I put this syntax, it gives me an error and says that the key did not match any lines in the table.
Can you help me with this topic?
Thanks in advance for the answer
1 Reply
Hi Anonymous ,
I found some similar posts you can refer to
Expression Error.: The key didn't match any rows in the table
how to resolve Power BI error - the key didn't match any rows in the table
Expression.Error: The key did not match any rows in the table
Expression.Error: The key did not match any rows in the table
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.