Power Platform Integrations (Read-only)
Power Platform and Dynamics 365 Integrations (Read-only)
Training and Consulting
Instructor Led Training
Dashboard in a Day for Women, by Women
Galleries
Community Connections & How-To Videos
COVID-19 Data Stories Gallery
Themes Gallery
Data Stories Gallery
R Script Showcase
Webinars and Video Gallery
Quick Measures Gallery
2021 MSBizAppsSummit Gallery
2020 MSBizAppsSummit Gallery
2019 MSBizAppsSummit Gallery
Events
Ideas
Custom Visuals Ideas
Issues
Issues
Events
Upcoming Events
Community Blog
Power BI Community Blog
Custom Visuals Community Blog
Community Support
Community Accounts & Registration
Using the Community
Community Feedback
Hi everyone,
All of sudden, PowerBI reports using SQL DB server are not working on PowerBI Desktop or Service. I've seen this message on PowerBI Desktop.
1. I tried refreshing the report in desktop and got the 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.)". Details is below.
2. If I uncheck the "Encrypt Connections" option in the "Edit Permissions" section in desktop the report refreshes however I still get the error once published to service.
3. There has not been any SSL certificate related update to the SQL Server.
Here is the detailed message that I received from PowerBI Desktop.
=================
DataSource.Error: Microsoft SQL: 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.)
Details:
DataSourceKind=SQL
DataSourcePath=xxxxxxxxxxx
Message=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.)
ErrorCode=-2146232060
Number=-2146893016
Class=20
===============
SQL Version : 15.0.2080.9
OS: Windows Server 2019 Standard (10.0)
We've found updates pending on our SQL server, installed them properly, and rebooted the server. But the issue is alive.
What should we do?
Thank you!
Microsoft Fabric Learn Together
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Power BI Monthly Update - April 2024
Check out the April 2024 Power BI update to learn about new features.
Fabric Community Update - April 2024
Find out what's new and trending in the Fabric Community.
