Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
@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.
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).
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |