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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors