Forum Discussion

mgib's avatar
mgib
New Member
3 years ago
Solved

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

  • mgib's avatar
    mgib
    New 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.

  • mgib could you explain what you have changed on the Azure AD Application Proxy to get this working? We have the same issue with a different application. The internal URL is working fine, but when we enter the AD proxy URL we get the DTD is prohibited error message.