Forum Discussion
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
2 Replies
sergej_ogSuper User
Hey Anonymous ,
- 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.
RegardsHi sergej_og ,
Thank you for the reply.
Can you help answer my Question in the original message.Cheers
CheenuSing