cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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

1 ACCEPTED SOLUTION
Anonymous
Not applicable

@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

View solution in original post

8 REPLIES 8
Quest
Advocate I
Advocate I

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.

Anonymous
Not applicable

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

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."

Anonymous
Not applicable

@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

Has anyone actually gotten PowerBI DirectQuery to work with Azure Managed Instance? We recently had to upgrade from SQL DB to managed instance, and we cannot get our PowerBI DirectQuery to connect like it used to. Wondering if there are extra firewall / security rules we need to circumvent now that it's managed instance?

Have you managed to get this working yet?
My organization is having some trouble also establishing a connetion in PowerBI when published.

Desktop is working fine.

Anonymous
Not applicable

HI @JWHND ,

 

Sorry to bump an old post, but I'm having the exact same issue. Works fine in Desktop, but once published to Power BI Online the data credentials are incorrect and the dataset cannot refresh. Have you been able to solve this?

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.