Help In configuring a power bi gateway server in Azure VM

[CheenuSing]

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

[sergej_og]

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

[CheenuSing]

Hi @sergej_og ,

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

Cheers

CheenuSing