Forum Discussion
Power BI Desktop With Azure VM SQL DB Data On One Drive Requires Gateway?
Same issue exist when using PowerQuery.
- Excel Workbook
- OneDrive Personal
- PowerQuery
- Azure VM SQL data source
PowerBI will not allow refresh. Says I need to install a gateway. According to the "Data Refresh" documentation this should work. Has anyone else been able to get this to work?
PaulBFelix Even I am facing a similar issue. Have posted few days back but no proper solution to this yet. You can see my post here.
Thanks ashishrj. Do you have any idea how Power BI determines that the data source is located in Azure? I'm guessing that the IP range is used. Not sure if it matters, but I used the new portal (portal.azure.com) to create my VM. The URL is formed a little differently since there is no cloud services. If the domain is used, then perhaps Power BI would work as expected when sourcing data from a VM created in the old portal. Just a guess. However, since I am able to refresh data from my VM using a Power Pivot workbook there must be something else going on.
A Azure VM with SQL server loaded is still consider a on-prem SQL server. Hence the need for a personal gateway.
Are you sure about that? If an Azure VM requires a gateway, then why does it not requie a gateway when using powerpivot?
I went through the trouble of creating a VM on the old portal which uses cloud services. Same issue.
PaulBFelix The difference in what "online" means is this. If you are using a VM hosted in the cloud, this is an Infrastructure as a Service (Iaas) and is treated as on-prem. If you are connecting to Azure SQL Database or Azure SQL datawarehouse these are Platform as a service (Paas) offerings and are considered "online". there are only certain situations that are completely dependent on what your datasource is where a gateway is not/is not required for powerpivot, and if you are connecting to a VM in an Iaas setup I would assume that would still require a gateway.
Here is a long list of scenerio's describing when a gateway is needed.
https://support.powerbi.com/knowledgebase/articles/474669-data-refresh-in-power-bi
