Forum Discussion

Plechazunga's avatar
Plechazunga
Regular Visitor
10 years ago

Enterprise Gateway Error on Refresh - SSL Provider: signature of the certificate cannot be verified

 

I get the error message displayed below on data refresh in Power BI Online when using an enterprise gateway connected to an on-premise SQL Server. The error on data refresh does not appear in Power BI Desktop.

 

I need advice what do I have to do that this data refresh works.

 

 

Now a description of all steps leading to the error.

 

Initial situation:

I have a Power BI Desktop, Enterprise Gateway on Server S-02 (two), SQL Server on Server S-01 (one) with Database DB-A, SQL Server Analysis Services on Server S-01 (one) with multidimensional Database DB-B.

 

The Enterprise Gateway is configured and ready to go

 

The data source in the gateway for the relational SQL Server DB-A

 

The data source in the gateway for the multidimensional SSAS DB-B

 

Remark: the PWA data source is the same as the first one and not used.

 

In Power BI Desktop I connect to the SQL Server and the relational DB-A, I create a report. I do not use the other multidimensional data source DB-B.

As you can see there are no values in the matrix. They shall appear on Refresh.

 

 

I change the data in the data source DB-A and refresh the report in the Power BI Desktop. This works.

 

Actual data appears in the report:

 

No I publish the report - without the last refresh of data - to Power BI Online.

Then I refresh the data source in Power BI Online with Refresh Now.

 

This does not work. I get the following error message (same as first picture above)

 

 

What do I have to do now that data refresh in Power BI Online with an Enterprise Gateway works?

 

Thank you in advance.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    did u resolve this issue?