Forum Discussion
Save Report to Secure (HTTPS) Server
EAWright 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.
This URL does not sound right. The default would URL is <server>/Reports but you can change the /Reports in the configuration manager. So it could be https://test.bi-reports/rs-bi or https://test.bi-reports/reports but the actual server url.
The fact that you got a 422 error (which is an unprocessable entity error) makes me think your portal URL is probably just https://test.bi-reports/rs-bi otherwise you would get a report server not found error.
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.
|INFO|39|Received request GET /api/v2.0/CatalogItems%28Path%3D%27/%27%29| RequestID =
|INFO|39|Sending response. Response code NT AUTHORITY\ANONYMOUS LOGON 403, Elapsed time 0:00:00.0026468| RequestID =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.
EAWright wrote:
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.
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.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 =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.
