Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Azure SQL Managed Instance with Power BI

Our organization is considering moving to Azure SQL managed instance. We are wondering how does Power BI interact with Azure SQL Managed. Here are a few questions I had:   1. Will Power BI desktop ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    amitchandak  Thank you.

     

    I was worried because Managed is not exactly cloud but our SQL Server on-prem DB managed on Azure Cloud via virtual network. The virtual network part got me questioning if the refreshes will work the same way as on cloud.

     

    Thanks,

    HV

amitchandak's avatar
amitchandak
Super User
6 years ago

refer :

https://community.powerbi.com/t5/Power-Query/Azure-SQL-Server-Managed-Instance/m-p/376246

https://www.mssqltips.com/sqlservertip/5953/create-power-bi-connection-to-azure-sql-database/

https://azure.microsoft.com/en-in/blog/securing-the-connection-between-power-bi-and-azure-sql-database/

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks amitchandak 

 

I went through the documentation. It was very helpful. The one question I still have is about scheduled refreshes. Does power BI scheduled refreshes work directly (since Azure SQL Managed is on cloud) or will it need a gateway to do so?

 

Best,

HV