Forum Discussion

ashishrj's avatar
ashishrj
Power Participant
10 years ago

SQL Server in Azure AM requires Gateway ??

I have implemented Power BI Dashbords using data from SQL Server in Azure VM 2 months back and scheduled refresh works fine without the need of Power BI Personal Gateway. But last week I tried creati...
Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

When you created the connection, did you use the Service interface or did you use Power BI Desktop?

 

My gut on this tells me that an Azure VM would essentially be treated like an on-premises data source versus something like Azure SQL DB, which is a service. I guess what I am saying is that I am somewhat surprised that refresh would work without the Power BI Personal Gateway.

ashishrj's avatar
ashishrj
Power Participant
10 years ago

Greg_Deckler I am using Power BI Desktop tool to create report. 

But I have already deployed reports using SQL Server in Azure VM without the use of Personal Gateway and even today it works well and refreshes daily. I don't know suddenly why this time it is creating an issue and asking for gateway :smileysad:

  • ashishrj's avatar
    ashishrj
    Power Participant
    10 years ago

    Does anybody have a solution to the above ??

    • PowerBIGuy's avatar
      PowerBIGuy
      Responsive Resident
      10 years ago

      A Azure VM with SQL server installed is most definitely treated as a on-prem SQL server. A Azure SQL server is a online dataset.