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...
ashishrj's avatar
ashishrj
Icon for Power Participant rankPower Participant
11 years ago
Yes you are correct! Data in Sql which is on Azure VM does not need a gateway. But your Azure VM needs to be in running state while refreshing data.
Also check your SQL server login credentials. It might have been expired. So reset it and keep your Azure VM running and then try refreshing.
  • RicSantos's avatar
    RicSantos
    Icon for Advocate I rankAdvocate I
    11 years ago

    ashishrj thank you for your reply!

    Unfortunately none of the cases u suggested happened, i made sure that either the credentials and the AZURE VM was running.

    andre Thank you but this is a VM with SQL and i could not find any "Allow Azure Services" on the machine settings.

    Still hoping to get a solution from @powerbiteam because all reported was working before the latest updates.