Forum Discussion
Power BI Desktop With Azure VM SQL DB Data On One Drive Requires Gateway?
Thanks Anonymous. Your explanation makes sense, but there are a couple things that don't add up. Please let me know if you happen to know what is going on with these two scenarios.
1. ashishrj post linked below describes this scenario working intermitently.
http://community.powerbi.com/t5/Service/SQL-Server-in-Azure-AM-requires-Gateway/m-p/8119#M3615
2. PowerPivot with an Azure VM SQL Server data source refreshes without the need for a gateway. I have this scenario working today and can verify that the refresh request are hitting the source database with is in an Azure VM running SQL Server.
Thank you in advance for taking the time to reply.
Here's a bit of info that makes this even more interesting. I can refresh a dataset linked to an Excel PowerPivot model saved to OneDrive which sources data from a server running SQL Server outside of Azure without a gateway. I totaly didn't expect that to work without a gateway, but it definately works. I can trace the request coming from Power BI when I initiate a data refresh.
I guess PowerPivot data models for whatever reason do not require a gateway. They use the SQL native client provider.