Forum Discussion
Essbase connector and HTTPS?
Hi all,
We are connecting successfully to Essbase using the connector via HTTP. This is a LAN connection, directly to the required server.
However, we want users to connect via HTTPS using Azure AD application proxy (AAP). So far, we have been unable to get this working.
When trying to connect we see the following exception every time:
"ExceptionResultMessage:
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."
I've followed the threads in this forum that mentioned the "DTD is prohibited" and looked at DNS and IPv6. I've also spent time looking at the traffic being generated. Most of the time, Power BI Desktop doesn't seem to make an outgoing connection when I attempt to connect via the HTTPS URL. Of course, no issue with the HTTP which routes internally, directly to the server.
However, before I go any further, can someone please advise whether this connector even supports HTTPS? Reviewing the following I suspect not since the only mention of HTTPS is to make sure it's disabled when experiencing connectivity issues:
https://learn.microsoft.com/en-us/power-query/connectors/essbase
Any feedback appreciated.
Thanks!
HTTPS is not the issue. I have now successfully connected to the same Essbase connector datasource using HTTPS. My issue appears to be Azure AD application proxy, it was not HTTPs.
2 Replies
- mgibNew Member
HTTPS is not the issue. I have now successfully connected to the same Essbase connector datasource using HTTPS. My issue appears to be Azure AD application proxy, it was not HTTPs.