Essbase Connector

[Anonymous]

Hello Everyone,

I'm having a hard time to connect to Essbase and access data using Essbase Connector in Power BI.

I have an error message when I try to connect to my Essbase Cube while i tried to connect to another Essbase test cube and it worked perfectly .

Can you please confirm if the connector works only with a recent version of Essbase or should it be working with all versions.

I'm really at this point

Thanks for the feedback

[v-eachen-msft]

Hi @Anonymous ,

Could you provide the detail error information? 

You could try to uninstall and re-install Power BI Desktop. 

Here is the document for your reference: https://blog.anbuchelva.in/hyperion/power-bi-and-essbase-initial-experiments/

[Anonymous]

Hello @v-eachen-msft ,

Thank you for your feedback.

The error message is the following :

I don't know if it is a problem of Essbase version or Connector issue. Can you please advice?

Thanks

[Anonymous]

Use the http://server:port/aps/XMLA or https://server/aps/XMLA URL.

Additionally check Essbase config:

The problem was: The default Essbase server entries in the provider config are wrong as they assume the provider and the Essbase services will both be running on the same host, that is not always the case.

The solution was: Delete the default entries, pointing to the web servers, and manually create an entry pointing to the actual Essbase host.