Forum Discussion
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 is that the data can't be refreshed. Instead I get a message saying I need to install the data gateway.
I also have an Excel workbook with a PowerPivot model saved on One Drive. This workbook data is also sourced from an Azure VM running SQL Server. After using the online "Get Data" feature I am able to schedule a data refresh. I verified that the data is getting pulled from the database. There is no gateway installed.
Is this a bug? Or am I missing something?
16 Replies
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.
