Forum Discussion

dtran's avatar
dtran
Icon for Helper II rankHelper II
9 years ago
Solved

can not refresh dataset (both from 'refresh now' and 'schedule refresh'

-setup gateway and connection -connection works when tested -however, both manual refresh and schedule refresh failed. here is the error message: "A connection was successfully established with ...
Need Help
dregan's avatar
dregan
Frequent Visitor
6 years ago

I had this issue, and none of the online resolutions worked.  The certificate was not expired, even though that was the error we were receiving.   We followed these steps:


Open SQL Server Configuration Manager, expand SQL Server Network Configuration, right-click Protocols for<server instance>, and then select Properties. On the Certificates tab you should see the details of the certificate that SQL Server is trying to use.

 

The certificate was blank by default but when we clicked the dropdown, it appeared.  We selected the certificate, hit apply and then needed to restart the SQL Server service. After we did this, the refreshes worked. 

  • mw099's avatar
    mw099
    Regular Visitor
    2 years ago

    I've already same problems with lost connection between Power Bi and MS SQL. The solution in my case was as dregan explained.