Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
David_54
Frequent Visitor

Problem refreshing PowerBI

We have a problem refreshing the data in PowerBI Service with the SQL Server.

If we try to refresh with PowerBI Desktop it works fine, but if we check the options 'encrypt connection' and 'trust certificate' in PowerBI Desktop it stop refreshing.

We already check the certificate date from the SQL Server and it is ok, we restart the SQL Server service and the whole server and it still not working, also we force the encryption in the SQL Server.

We suppose that the PowerBI Service is encrypting the connection automatically, how can we unmarked the option to encrypt the connection like in PowerBI Desktop?

 

Complete log error: 'A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The received certificate has expired.)'

 

2 REPLIES 2
David_54
Frequent Visitor

Hi Gilbert, thanks for your reply.

 

The SQL certificate expires in 2023 and many people try to refresh the PowerBIs in the cloud.

The people we refresh are in UTC+1, but we have the date updated.

GilbertQ
Super User
Super User

Hi @David_54 


From the error either the certificate has expired if you could review the dates on the certificate.


The other thing I have seen is when the computer where you are running it from does not have the right date/time set. If you could look into that too?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.