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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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

Top Solution Authors
Top Kudoed Authors