Forum Discussion
PaulBFelix
10 years agoAdvocate II
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...
ashishrj
10 years agoPower Participant
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.
PaulBFelix
10 years agoAdvocate II
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.