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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
stuart
New Member

RE: Power BI: Can't access SQL Server data using Power BI Enterprise Gateway

Hi, 

 

- I have installed PowerBI enterprise gateway on an onpremis computer. 

- I have created two data sources in PowerBI whcih point to two different sql server database tables.

- I can access the databases from that computer.

- My users have adequet permisions.

- PowerBI says they are Online and good to go.

- I can't see the data in Power BI.

 

What do I do now? Is this a bug? This is really frustrating.

 

After I did a bit of investigation I am getting the following messages in the log:

 

Failed to execute the command ' -SetupGatewayForAppMode b9eed145-063c-4663-abe1-e876a82f2095@c90fbba4-a23b-43fe-ab72-b13e490e48d9@202a1df9-0664-485f-8e29-ee8e334212da@sea#/LvGiH6S89xXFMFdz95SzYsToG7ovAjn2BiGddUiPQk='. Error message: An error occurred while sending the request.
at Microsoft.DataTransfer.DIAgentHost.NamedPipeControllers.NamedPipeGatewayClientController.VerifyGatewayKey(String gatewayKey)
at Microsoft.DataTransfer.DIAgentHost.NamedPipeServer.PipeServerThread(Object data)
An error occurred while sending the request.
caused by The request was aborted: Could not create SSL/TLS secure channel.

 

An error occurred while sending the request.
at Microsoft.DataTransfer.DIAgentHost.NamedPipeControllers.NamedPipeGatewayClientController.VerifyGatewayKey(String gatewayKey)
at Microsoft.DataTransfer.DIAgentHost.NamedPipeServer.PipeServerThread(Object data)
An error occurred while sending the request.
caused by The request was aborted: Could not create SSL/TLS secure channel.

 

This would indicate there is a firewall problem but what  address is it trying to access. If it is a connection problem why is PowerBI Enterprise gateway saying everything is ok.  

 

 

Regards

Stuart Davies

 

 

 

 

 

Stuart

0 REPLIES 0

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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