Forum Discussion
Advocate IData Refresh on SQL Server on Microsoft Azure Virtual Machine
Just for an update on the topic...
No solution to this case... Just had to instal Power BI Personal Gateway on Azure VM, and lost he ability to connect to SSAS tabular aZure on same machine.
The update and refresh are working with the personal gateway as explained in https://support.powerbi.com/knowledgebase/articles/649846-power-bi-personal-gateway
Thank you all for your support and suggestions.
are there any guidlines how to connect to a SQL DB on Azure VM. I have tried all sorts but seems like i cant get it to work
Helper II believe a SQL Database on an Azure VM is IaaS and Power BI requires a data gateway to connect to such a data source. I am also interested to see when Microsoft Power BI Development team plans on addressing this? Refreshes depend on a personal gateway now which requires laptops to be on for the refreshes to work. This doesn't make sense....
http://blogs.msdn.com/b/powerbi/archive/2015/07/07/refresh-for-on-premises-sources-is-here.aspx
Does this help?
Tks & Rgds,
Alay