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

maxxmilo's avatar
maxxmilo
Helper I
5 years ago

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?

JWHND's avatar
JWHND
Regular Visitor
5 years ago

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's avatar
    Anonymous
    Not applicable
    5 years ago

    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?