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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
CheenuSing
Community Champion
Community Champion

Help In configuring a power bi gateway server in Azure VM

Hi All,

 

1.  We have a serverless sql server in azure portal.

2. We have a Dev VM in azure portal

3. In the Dev VM, built reports in power bi using the Get Data--> Azure Sql Database, using the server pointing to 1 above.

Question 1 : is this type of connection considered on-premise and hence need gateway service to refresh the data once the report is published in service.

 

4. We have a VM in azure portal to install and act as Gateway Server.

5. For the report  built and published in point 3 above, if a datasource connection is needed to configure using the Gatewayconnection, how to specify the database server at point 1 in that connection.

 

Appreciate any help with the steps to establish the above.

 Cheers

 

CheenuSing

 

 

 

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!
2 REPLIES 2
sergej_og
Super User
Super User

Hey @CheenuSing ,
 - if you have a premium in Service you can usually use the v-net gateway, provided by MS. But it's a premium feature.
 - on the other hand (if v-net gateway not possible) you can set up a VM in your azure portal and install there your Gateway client.
 - if already have a gateway running you can register this one in azure. Then it's usable for other components like Logic Apps etc.
-------------------------
After you have registered your gateway you can create connections for your semantic models to connect and refresh the data. But pls set up a gateway first and then come over here again. Then we can help you by creating a connection.

Regards

Hi @sergej_og ,

 

Thank you for the reply.
Can you help answer my Question  in the original message.

Cheers

 

CheenuSing

 

 

 

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!