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

Hi GuyInACube,  Are you talking about Azure SQL Datbase or Azure VM running SQL database.  This thread is about the latter.  I'm a pro trial user, and I get the gateway required message.

GuyInACube's avatar
GuyInACube
Administrator
10 years ago

Sorry, was talking about Azure SQL Database.  Didn't see the VM part.

 

Although that made me think of something.  It could come down to what you are putting in the Server name piece.  I'd have to validate, but we use the same source for Azure SQL Database vs. On-Prem.  It really comes down to the server name.  Azure SQL Database is a well known domain.

 

*.database.windows.net

 

The FQDN for Azure VMs is *.cloudapp.net.

 

Are you doing something like entering the FQDN within Power Pivot, but the machine name only in PBI Desktop/Power Query?  

myserver.cloudapp.net

 

vs. 

 

myserver

 

I'm wondering if that is causing the behavior to be different.  If it is the full FQDN for both, then i'm not sure.  But the FQDN for Power Pivot, and machine name for PBI Desktop/Power Query could explain it.  For cloudapp.net we know that is in the cloud.