PowerBI database server connection issue

Hi dcvman,

Thank you for reaching out through the Microsoft Fabric Community Forum.

Based on my understanding, the error message "The target principal name is incorrect" generally occurs when encryption is enabled without explicitly trusting the certificate.

To configure Power BI Report Server to use Encrypt=True; TrustServerCertificate=True, please follow the steps below, which may help to resolve the issue:

1. Open the RSReportServer.config file located at:
   C:\Program Files\Microsoft SQL Server\MSRSxx.<InstanceName>\Reporting Services\ReportServer
2. Locate the <ConnectionProperties> section.
3. Update the ConnectString as shown below:
   <ConnectString>Data Source=192.168.1.53;Initial Catalog=ReportServer;Encrypt=True;TrustServerCertificate=True</ConnectString>
4. Save the changes and restart SQL Server Reporting Services.

This configuration bypasses the certificate name verification and resolves the encryption-related login error.

For your reference, please find the relevant documentation here:
Reporting Services configuration files - SQL Server Reporting Services (SSRS) | Microsoft Learn

If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will assist other community members facing similar issues.

Should you have any further queries, please feel free to contact the Microsoft Fabric community.

Thank you.