Essbase connector with MDX issue

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.