Essbase (Beta) Connector

[Anonymous]

Hi, 

I am trying out the new ESSBASE (Beta) connector on Power BI desktop. 

I took the following steps: 

1) Enter server

2) Enter credentials 

Getting an error message: 

For security reasons DTD is prohibited in this XML document. To enable DTD processing set the DtdProcessing property on XmlReaderSettings to Parse and pass the settings into XmlReader.Create method.

Any idea how to address the issue? It would be super cool to connect to Essbase directly. 

Thanks in advance for your help! 

Marcin 

[Anonymous]

This error is happening with me, someone help me?

"A conexão subjacente estava fechada: Erro inesperado em um recebimento"

[Anonymous]

This error is happening with me, someone help me?

The underlying connection was closed: Unexpected error on a receipt

[Anonymous · Accepted solution]

Hi @Anonymous

you should use the server connection string like this

http://server: port/aps/XMLA

written a blog post on the same here: https://blog.anbuchelva.in/Hyperion/power-bi-steps-to-connect-essbase-using-essbase-connector-beta/

hope this helps!

[Anonymous]

Wow - thanks so much for your blog post. 100% worked 🙂 So happy I can dig into the data. 

[Anonymous]

@Anonymous I was wondering how you were able to fix the "For security reasons DTD is prohibited in this XML document". I tried the URL provided (/aps/XMLA) but I still get this error.

Thanks!

[a131001]

Same issue here, please let me know if you find a solution. Thanks!

Brgds

Christian

[v-shex-msft]

Hi @Anonymous,

I think this issue is more related to your datasource itself, the error message also told about this:

For security reasons DTD is prohibited in this XML document. To enable DTD processing set the DtdProcessing property on XmlReaderSettings to Parse and pass the settings into XmlReader.Create method.

Reference link:

DTD prohibited in xml document exception

Regards,

Xiaoxin Sheng

[larjohn]

Any idea how I can fix this? Do I go somewhere in settings?

Also, Essbase normally uses TCP/IP but there is a Java API so I guess that could be dumping out XML stuff