Apply Parameter

[Anonymous]

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

[v-stephen-msft]

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.