Essbase connector with MDX issue

[grangema]

Hi there,

We are trying to connect PowerBI to an Essbase datasource using the Import method connection together with a MDX query.

We could validate the server URL creating a direct query connection. Now and using Import method together with MDX the following error message is displayed: The key didn't match any rows in the table

Here is the query :

We previously tested the query in Essbase Administration console (EAS) so we are sure that the query is fine.

Is there any specific setting for the connection string or any specific syntax we have to use for the MDX query?

Thank you very much for your help.

[v-stephen-msft]

Hi @grangema ,

I found some similar posts and a blog you can refer to

Expression.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 didn't match any rows in the table

Understanding The “The key didn’t match any rows in the table” Error In Power Query In Power BI Or E...

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.

[SRX]

Stephen, thank you for your interest and feedback. However and sadely these are not Essbase source related posts!

SRX