Forum Discussion
mjoseph111
3 months agoHelper II
Refresh failures for PBI dashboard
We are experiencing Power BI refresh failures for one of our Dashboard that connects to SQL Server through the on‑premises gateway using Windows Authentication. This dataset has been refreshing succe...
anilelmastasi
3 months agoSuper User
Hello mjoseph111 ,
Please check this: https://learn.microsoft.com/en-us/answers/questions/2157184/ssl-certificate-chain-not-trusted-error-in-sql-ser
Also in power bi service, go to Manage Gateways. Find your SQL Server data source and look for an option to "Trust server certificate" or "Encrypt connections".
If this solved your issue, please mark it as the accepted solution. ✅