cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Irisvb Frequent Visitor
Frequent Visitor

Cannot connect to Power BI Gateway that has already been set up

Hi everyone, 

 

I've been having some trouble at one of my client's. They have asked me to make a new report page in an existing report. I have the report, I cannot use Power Query because I do not have access to all the databases that connect in this file. 

For this report page, I need to connect to a SQL database. The administrator had given me the credentials and I got this error message everytime I tried to connect: 

1.jpg

After being in the dark for two days, someone else within the company informs me that it is not possible to connect directly to the SQL server but that they have a gateway set up within Power BI. 

Whenever I look at "Manage gateways" within Power BI, it says that I do not have any gateways yet. I'm assuming (however I cannot tell because I cannot find online what happens inside Power BI when you are not the person to have configured the gateway), that it should show an available gateway to which I can make a connection. 

 

I checked with the administrator and he has put me as user in the gateway connections. 

2.png

(Sorry, had to blur the gateway and names for confidentiality reasons). 

How can I access this SQL database through the gateway?  

I am completely in the dark and I really need to know whether to check with the Power BI guy, database guy, both, or if there is something I can do myself so I can access this database. 

1 ACCEPTED SOLUTION

Accepted Solutions
Ross73312 Super Contributor
Super Contributor

Re: Cannot connect to Power BI Gateway that has already been set up

@Irisvb  It should be mentioned that the purpose of the Gateway is to allow reports within the service (sitting in Microsoft's cloud) access into the secure company network.  Gateways don't work for a developer using Power BI Desktop attempting to make changes within Power Query.

 

If you don't have direct access to the data source, ask the client to provide you with an RDP machine that can't get direct access.  This should let you make Power Query modifiations.  I have a similar problem with some Azure SQL databases that our Firewall doesn't let me access.  I need to connect to a VM thats in Azure, then i can make the direct connections i need.


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


View solution in original post

2 REPLIES 2
Super User
Super User

Re: Cannot connect to Power BI Gateway that has already been set up

Hi there

You have to use the same details that the gateway uses for the connection to the SQL Server in your PBIX

That should then allow you to connect.

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog
Ross73312 Super Contributor
Super Contributor

Re: Cannot connect to Power BI Gateway that has already been set up

@Irisvb  It should be mentioned that the purpose of the Gateway is to allow reports within the service (sitting in Microsoft's cloud) access into the secure company network.  Gateways don't work for a developer using Power BI Desktop attempting to make changes within Power Query.

 

If you don't have direct access to the data source, ask the client to provide you with an RDP machine that can't get direct access.  This should let you make Power Query modifiations.  I have a similar problem with some Azure SQL databases that our Firewall doesn't let me access.  I need to connect to a VM thats in Azure, then i can make the direct connections i need.


   

              Did I answer your question? Mark my post as a solution!
       

Proud to be a Datanaut!


   


View solution in original post

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)