Save Report to Secure (HTTPS) Server

Question

While trying to save a report from Power BI Desktop (May 2019) to our Report Server instance I am getting an Error: Unexpected Error message.

Our Report Server URL is along the line of https://test.bi-reports/rs-bi/reports and as near as I can tell the save function is falling over on trying to authenticate on the server to complete the action.

Looking at the RSPortal log on the Repot Server there is a message
|Sending response. Response code NT AUTHORITY\ANONYMOUS LOGON 422,

d_gosbell · Answer

EAWright&nbsp;wrote:
Our Report Server URL is along the line of https://test.bi-reports/rs-bi/reports and as near as I can tell the save function is falling over on trying to authenticate on the server to complete the action.&nbsp;
&nbsp;

This URL does not sound right. The default would URL is &lt;server&gt;/Reports but you can change the /Reports in the configuration manager. So it could be https://test.bi-reports/rs-bi&nbsp; or&nbsp;https://test.bi-reports/reports but the actual server url.&nbsp;
&nbsp;
The fact that you got a 422 error (which is an unprocessable entity error) makes me think your portal URL is probably just&nbsp;https://test.bi-reports/rs-bi otherwise you would get a report server not found error.

eawright · Answer

I have used the appropriate URL and I am getting an error message returned that I do not have access which is echoed in the log files which identifies me as an anonymous user.

While accessing the site with a browser I am prompted for credentials which are reflected in the logs so I am not sure what/ how to get PBI Desktop to ask for/ pass credentials. I would have thought that launching the PBI Desktop FROM the browser would pass who I am along with it.

d_gosbell · Answer

EAWright&nbsp;wrote:
&nbsp;
While accessing the site with a browser I am prompted for credentials which are reflected in the logs so I am not sure what/ how to get PBI Desktop to ask for/ pass credentials.

This is the cause of your issue as I believe PBI Desktop only supports integrated security for publishing reports. As far as I am aware it does not have the ability to prompt for credentials and a browser can't pass credentials to another app. If you have PBIRS setup like this for a reason then I think your only option is to save the report to a local folder then use the upload option in the browser.

eawright · Answer

That approach is something that I tried initially but every time, even the most simple report returns:An error has occurred.There was an error uploading your .pbix file. Verify that the file has not been corrupted and that the file extension matches the format of the file.&nbsp;In looking at the log files for this error I see:|ERROR|20|The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.| RequestID = |INFO|55|Sending response. Response code DOMAIN\EAWR 422, Elapsed time 0:00:00.0265593| RequestID =&nbsp;My client is a government agency and all of their services are required to be secure (HTTPS) which is a pretty fundamental capability of a modern system.I am kind of surprised that I am having this level of difficulty with getting it to work, asking the security folks to open port 80 is just not an option.

d_gosbell · Answer

EAWright&nbsp;wrote:
Could not establish trust relationship for the SSL/TLS secure channel.

That could indicate an issue with your certificate. I'm not really an expert on certificates, but if there is a problem with the trust relationship to the certificate authority it could cause an issue like this. Maybe go back and talk to whoever generated and installed the certificate.
&nbsp;
I've setup a couple of Report Server instances with HTTPS and it was just a matter of getting our domain admins to create and install a certificate and then I picked the installed certficate from the Report Server Configuration Manager and it all worked. So Report Server definitely supports HTTPS and it's normally pretty easy to setup.
&nbsp;

Forum Discussion

Save Report to Secure (HTTPS) Server

10 Replies

Related content

Row Level Security - SSAS/Report Server

Role Level Security

Governance & Security

SECURITY

Page level security