Forum Discussion
Essbase (Beta) Connector
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
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!
8 Replies
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!
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
Same issue here, please let me know if you find a solution. Thanks!
Brgds
Christian
