topic Re: Issues with API Call (Web Source) in HTTPS on report Server in Report Server

Issues with API Call (Web Source) in HTTPS on report Server

Gianluca88 — Thu, 17 Nov 2022 14:59:31 GMT

Hi all,

when I tried to test connection on Report Server for an API HTTPS the error in the below image occurs. I underline that the same issue DOES NOT happen in Power Bi Desktop for Report Server. Could you have any suggestion?

thanks,

Re: Issues with API Call (Web Source) in HTTPS on report Server

Anonymous — Fri, 18 Nov 2022 02:08:49 GMT

Hi Gianluca88 ,

Please try below steps:

Clear the Secure Sockets Layer (SSL) state. To do this, follow these steps:

In Internet Explorer, click Tools, and then click Internet Options.
Click the Content tab, and then click Clear SSL state.

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Issues with API Call (Web Source) in HTTPS on report Server

Gianluca88 — Fri, 18 Nov 2022 08:12:42 GMT

Hi @v-binbinyu-msft ,

thanks for your reply. Unfortunately this trick does not work. I changed Internet Option and then restarted browser on the machine where report server is installed, but with no avail. The very strange thing is that the same API call does work when I call if from the same browser (obviously with the appropriate certificate installed), but it does not work when I perform the call inside the report server. Any other suggestion? Could you recommend raising a support /bug ticket to Microsoft?

Thanks,

Re: Issues with API Call (Web Source) in HTTPS on report Server

Gianluca88 — Tue, 22 Nov 2022 13:31:27 GMT

Hi @v-binbinyu-msft ,

coudl you help me with this topic?

Many thanks,

Re: Issues with API Call (Web Source) in HTTPS on report Server

d_gosbell — Tue, 22 Nov 2022 22:30:31 GMT

Is this an internal web server that you are hitting? One possible explanation is that your client PC has a root certificate installed from an internal Certificate Authority which is not installed on the Report Server machine. Your IT department should be able to help if this is the case.

You could also try check the RSPortal* and ReportingServicesService* log files (usually found at C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles) to see if there are more details about this error in either of them.

Re: Issues with API Call (Web Source) in HTTPS on report Server

Gianluca88 — Sat, 26 Nov 2022 18:24:55 GMT

Hi d_gosbell ,

thanks for your response. It turns out to be enough to install the certificate in the machine , following for example the following link Import and Export Certificate - Microsoft Windows :: Import and Export Certificate - Microsoft Windows :: GlobalSign Support

Thanks again,