Forum Discussion

PaulBFelix's avatar
PaulBFelix
Advocate II
10 years ago

Power BI Desktop With Azure VM SQL DB Data On One Drive Requires Gateway?

My data source is an Azure VM running SQL Server.  I used Power BI Desktop to save my *.pbix file to One Drive.  I then imported the *.pbix to Power BI using the "Get Data" online feature.  Problem i...
Need Help
PaulBFelix's avatar
PaulBFelix
Advocate II
10 years ago

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.

PowerBIGuy's avatar
PowerBIGuy
Responsive Resident
10 years ago

A Azure VM with SQL server loaded is still consider a on-prem SQL server. Hence the need for a personal gateway.

  • PaulBFelix's avatar
    PaulBFelix
    Advocate II
    10 years ago

    Are you sure about that?  If an Azure VM requires a gateway, then why does it not requie a gateway when using powerpivot?