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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
miguel1206
Helper II
Helper II

The server name provided doesn't match the server name on the SQL Server SSL certificate.

Hi all, can You help me with the next issue? When I refresh data from PowerBI.com using the On-Premises Gateway appears the next message: The server name provided doesn't match the server name on the SQL Server SSL certificate.)

 

I have reinstalled the On-Premises Gateway, reboot SQL services, but message continues appear

 

 

Best regards

1 ACCEPTED SOLUTION

@miguel1206 See this thread you may need to use the Fully Qualified Domain Name. This error indicates to me that this is just a wrong connection string as opposed to something wrong with the gateway setup.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

4 REPLIES 4

@miguel1206 See this thread you may need to use the Fully Qualified Domain Name. This error indicates to me that this is just a wrong connection string as opposed to something wrong with the gateway setup.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

Thank for your response, I have installed ADO.NET and set in PowerBI.com SERVERNAME.contoso.com\DBInstance as server name in gateway connection all good but when I want to set that DataSource to refresh data in Gateway connection, doesn't appears, I need to reinstall the on-premises gateway?

 

Best regards

To answer my question, if in Gateway configuration in PowerBI.com set: SERVERNAME.contoso.com\DBInstance, the same server name need to set in the Source configuration in PowerBi Desktop

 

Regards

Hi,

 

This worked for me, in additional i just had to restart my SQL server in order to populate my FQDN names in PowerBI gateway. ( I used FQDN names for all data sources in powerBi Desktop by going into Edit Query-->Advanced Editor, then configured datasources under powerBi gateway using same FQDN names, then restarted SQL Service then only it populated into dataset under gateway connection for report). 

 

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.