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.
PaulBFelix Are you sure you don't have a Personal Gateway installed. I've reproduced your scenarios and in all instances have been asked to install a personal gateway. Do you use a personal gateway for any other of your datasources? I don't see how storing a PowerPivot file in one-drive connected to a on-perm SQL server would bypass the need for a gateway.
Hi PowerBIGuy. I agree, something doesn't add up. I sent a private message with my email address. Let me know when you can meet, and I'll send a goto meeting invite. I have never installed a gateway on any of the systems I am using to test with.
