Forum Discussion
Power BI Desktop With Azure VM SQL DB Data On One Drive Requires Gateway?
When using Azure SQL Database as the Data Source is a bit different. It will allow for refresh without a gateway if you are a Pro user. All you need to do is enter your credentials.
If you are a Free user, it will want the Personal Gateway present to do a refresh.
In both cases, when i tried it, the file on OneDrive for Business, where it originated from, was not updated.
If you are getting an error saying the gateway was not reachable, it is because you are a Free user.
Hi GuyInACube, Are you talking about Azure SQL Datbase or Azure VM running SQL database. This thread is about the latter. I'm a pro trial user, and I get the gateway required message.
Sorry, was talking about Azure SQL Database. Didn't see the VM part.
Although that made me think of something. It could come down to what you are putting in the Server name piece. I'd have to validate, but we use the same source for Azure SQL Database vs. On-Prem. It really comes down to the server name. Azure SQL Database is a well known domain.
*.database.windows.net
The FQDN for Azure VMs is *.cloudapp.net.
Are you doing something like entering the FQDN within Power Pivot, but the machine name only in PBI Desktop/Power Query?
myserver.cloudapp.net
vs.
myserver
I'm wondering if that is causing the behavior to be different. If it is the full FQDN for both, then i'm not sure. But the FQDN for Power Pivot, and machine name for PBI Desktop/Power Query could explain it. For cloudapp.net we know that is in the cloud.