Forum Discussion
Save Report to Secure (HTTPS) Server
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.
EAWright 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.
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.
So I worked with with a second set of eyes to test the out the Certificate, and in continuing to poke around we discovered that we can upload pretty much any file except a .pbix. (.txt, .pdf etc)
We even tried uploading a .txt file with the extension changed to .pbx and received the same could not establish trust relationship error.
Could there be a configuration that I missed when setting up the server/ service ?
I should also mention that I confirmed that the version of the desktop software matches the server version number