Essbase connector xmla parsing error while exploring its plans (oracle apps essbase hyperion)

[shahidmehmood]

I have successfully connected Power BI desktop to oracle hyperion essbase database but got error when tried to open its plans

"An error occured while parsing entityname at line 219 position 41" 

Print screen is attached.

[shahidmehmood]

Power BI Version: 2.128.952.0 64-bit (April 2024) 

Oracle Hyperion version is 11.2.7

[shahidmehmood]

XML connection established to server successfully but still unable to browse Hyperion data base

[Anonymous]

Hi @shahidmehmood ,

Please check and confirm the following info:

• Essbase version
• Upgrade the version of Power BI Desktop to the latest one 

Power Query Essbase connector - Power Query | Microsoft Learn

Essbase 11.1.2.x version is supported.

---

The following links is the thread which has the similar problem as yours, hope its solution help you solve your problem.

Solved: Essbase Connector - XMLA Parser Error - Microsoft Fabric Community

Best Regards