Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Unable to access DB from Azure Virtual Machine using Gateway

Hi Team, The dashboard is created under this PC and the SQL Server data source is import from cloud server and the server is created using Microsoft Azure. Through design phase, im able to refresh...
Need Help
ibarrau's avatar
ibarrau
Super User
5 years ago

Hi. The gateway is used for on premise data. You have to install a client in a machine with access to the data. If your only data source is in Azure SQL Server Database and you haven't configure a vnet around it. Then you don't need gateway. You can just go to "Schedule Refresh" setting for the Dataset in Power Bi Service. Look for the option "Data Source Credentials". You will see a small X and "Edit Credentials". Add the credentials to the SQL Server and you would be ready to go without a gateway.

Hope that helps,

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Ibarrau,

     

    The data source is created using Microsoft SQL Server Management Studio 18 inside virtual machine using Microsoft Azure, not Azure Cloud Database.

    In that case, should i still need on-premise gateway to get access to the data.
    Additional, i had download on-premise gateway (personal mode) in cloud server and try out, the personal gateway is available under configuration.

    Issue is on credential where error display as below,

    The only credential that i can't configure is server and database name.

     

    Thanks.

    • ibarrau's avatar
      ibarrau
      Super User
      5 years ago

      I see. You can try the Gateway in standard mode that is more stable and secure. That one will let you configure from Service the instance and credentials.

      Hope that works.