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
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!

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!

Feb2025 NL Carousel

Fabric Community Update - February 2025

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