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.
