Forum Discussion

Gianluca88's avatar
Gianluca88
Resolver I
3 years ago
Solved

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

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,

g.

 

  • 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.

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Gianluca88 ,

    Please try below steps:

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

    1. In Internet Explorer, click Tools, and then click Internet Options.
    2. 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.

    • Gianluca88's avatar
      Gianluca88
      Resolver I

      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,

      g

       
  • 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.