Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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
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