Forum Discussion

RicSantos's avatar
RicSantos
Icon for Advocate I rankAdvocate I
11 years ago
Solved

Data Refresh on SQL Server on Microsoft Azure Virtual Machine

I have a scenario where the data refresh has been working manually and automatically, and from 07/07/2015 i started receiving errors: "Last refresh attempt failed. Your gateway is offline or could n...
andre's avatar
andre
Icon for Memorable Member rankMemorable Member
11 years ago
I am sorry, this setting is for SQL Azure PaaS and not VM... I just realized I misunderstood your issue. Is it possible that this is firewall issue on the VM?
  • PBI77's avatar
    PBI77
    New Member
    11 years ago

    are there any guidlines how to connect to a SQL DB on Azure VM. I have tried all sorts but seems like i cant get it to work

    • Alay's avatar
      Alay
      Icon for Helper I rankHelper I
      11 years ago

      I believe a SQL Database on an Azure VM is IaaS and Power BI requires a data gateway to connect to such a data source. I am also interested to see when Microsoft Power BI Development team plans on addressing this? Refreshes depend on a personal gateway now which requires laptops to be on for the refreshes to work. This doesn't make sense....

       

      http://blogs.msdn.com/b/powerbi/archive/2015/07/07/refresh-for-on-premises-sources-is-here.aspx

       

      Does this help?


      Tks & Rgds,

       

      Alay

    • andre's avatar
      andre
      Icon for Memorable Member rankMemorable Member
      11 years ago

      you would connect to a sql db in azure vm the same way you would connect to a sql db on premise.  if you cannot connect, most likely your networking/firewall is making it difficult for you so i would escalate this issue to your network group