Are you working in a distributed Hyperion environment?
I was testing this in our environment and was running into similar problems with connecting to PowerBI, however, when I tried testing the connection in a "sandbox" environment, where all Hyperion applications/components are installed on a single server, I was able to connect to PowerBI using the same connection string you identified above, http://EssbaseServer:19000/aps/XMLA. So from my testing so far, my conclusion is that the Essbase (Beta) PowerBI Connector does not yet work in a distributed Hyperion environment. We have reached out to Microsoft for guidance/support but have not yet heard anything new. I believe they are aware of this issue and (hopefully) working on addressing it, but you may want to reach out to Microsoft as well.
Good luck - and please let us know if you make any progress on this topic.
does anyone gets any update from Microsoft yet?
Hi, If you haven't figured it out, the XMLA connection URL should be the workspace/foundation server not the Essbase server.
(Re posting from another thread)
I did use the correct APS URL (as mentioned in your comment) and URL goes in.
But then there is no login screen prompt and instead it is thinking the server name mentioned in the URL is the Essbase server (It tries to connect to the port 1423 on that server)
Here is error message I am getting.
Cannot connect to Essbase Server at “(servername in URL)”. Network Error :Failed to connect to [(ServerNameINURL):1423]”
Any help is appreciated
Are you able to establish connection between Oracle Essbase and Power BI? If yes, What are the versions of Essbase and Power BI you are using? We are currently on Hyperion 18.104.22.168 version and wanted to know if Essbase can be integrated with Power BI directly without the help of any third party tools.