Forum Discussion

desertislesql's avatar
desertislesql
Most Valuable Professional
10 years ago
Solved

Gateways for Azure SQL Database VM deployed from Power BI Desktop

If my datasource is an Azure SQL Server VM, and I have used Power BI Desktop to create and deploy a model to Power BI Service, when I want to refresh my data, do I need to install the new gateway to refresh my data? It doesn't make sense to me that I would since the data is stored in the cloud and not locally, but I wanted to confirm.

  • Anonymous's avatar
    Anonymous
    10 years ago

    desertislesql Grr. I was just going to post an edit to validate that... IAAS is considered "on-premises" So you would need a gateway. Sorry if I mis-understood the initial question. There is a slight wording difference in names. (PAAS = Azure SQL DB), (IAAS = SQL DB on Azure)

    IAAS = Need a Gateway

    PAAS = Do not need a Gateway

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    desertislesql Nope, you are right. There is a chart on this page you can use for quick reference as well.

    • desertislesql's avatar
      desertislesql
      Most Valuable Professional

      Thank you. I am glad to have that confirmed in writing so the next person looking to use  Azure SQL Server as an IAAS source will know that no gateway is required. Appreciated the quick response.

      • Anonymous's avatar
        Anonymous
        Not applicable

        desertislesql Grr. I was just going to post an edit to validate that... IAAS is considered "on-premises" So you would need a gateway. Sorry if I mis-understood the initial question. There is a slight wording difference in names. (PAAS = Azure SQL DB), (IAAS = SQL DB on Azure)

        IAAS = Need a Gateway

        PAAS = Do not need a Gateway