Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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!
This error is happening with me, someone help me?
"A conexão subjacente estava fechada: Erro inesperado em um recebimento"
This error is happening with me, someone help me?
The underlying connection was closed: Unexpected error on a receipt
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!
Wow - thanks so much for your blog post. 100% worked 🙂 So happy I can dig into the data.
@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!
Same issue here, please let me know if you find a solution. Thanks!
Brgds
Christian
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |