Forum Discussion
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 will able to connect to Azure SQL Managed using DirectQuery?
2. Will we still need to have a gateway to connect PBI service to PBI desktop for enabling scheduled refreshes?
Thanks,
HV
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
8 Replies
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/
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 LinkedinThanks 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
Refer :https://docs.microsoft.com/en-us/power-bi/refresh-data#accessing-cloud-data-sources
"Datasets that use cloud data sources, such as Azure SQL DB, don't require a data gateway if Power BI can establish a direct network connection to the source. Accordingly, you can manage the configuration of these data sources by using the Data source credentials section in the dataset settings. As the following screenshot shows, you don't need to configure a gateway connection."
We are facing the same issue.
Works fine in Desktop, but once published to Power BI Online, the dataset cannot refresh.
Can someone help with a resolution to the same.
