Forum Discussion

RosG's avatar
RosG
Frequent Visitor
1 year ago
Solved

Connect from PowerBI Desktop to Azure SQL database using EntraID

I have seen some old posts saying it is not possible to connect from PowerBI Desktop to Azure SQL databases using EntraID.  Is this still the case?   What is the best work around from a security pe...
Need Help
  • suparnababu8's avatar
    suparnababu8
    1 year ago

    Hi RosG 

     

    Connecting from Power BI Desktop to Azure SQL databases using Entra ID (formerly Azure AD) is indeed possible. Here are the steps and best practices to ensure a secure connection using AD accounts:

    Connecting Power BI Desktop to Azure SQL Database Using Entra ID

    1. Open Power BI Desktop:

      • Go to Home > Get Data > Azure > Azure SQL Database.

    2. Enter Server and Database Information:

      • Provide the Server name and Database name.

    3. Authentication Method:

      • Select Microsoft Entra ID (formerly Azure AD) for authentication.
      • Ensure you are signed in with the appropriate AD account.

    4. Firewall Configuration:

      • Ensure that your Azure SQL Database firewall settings allow access from Power BI Desktop. You might need to add your client IP address to the allowed list.

    Best Practices for Security

    1. Use Managed Identities:

      • If possible, use managed identities for Azure resources to authenticate to Azure SQL Database. This approach eliminates the need to manage credentials manually.

    2. Enable Single Sign-On (SSO):

    3. Use Private Endpoints:

      • Configure private endpoints for your Azure SQL Database to ensure that traffic between your Power BI service and the database remains within the Azure network.

    Alternative Approaches

    1. Paginated Reports:

      • While paginated reports require users to sign in, you can use Power BI Embedded to embed these reports in SharePoint or Teams. This approach provides a seamless experience without requiring additional sign-ins.

    2. Power BI Service:

      • If direct connection from Power BI service to Azure SQL Database is not feasible, consider using an On-premises Data Gateway. This allows you to connect securely to your database and run stored procedures.

    If you need additional information pls go through below links

    https://learn.microsoft.com/en-us/power-bi/connect-data/service-azure-sql-database-with-direct-connect

    https://community.fabric.microsoft.com/t5/Desktop/Connect-to-Entra-ID-data/td-p/3516002

    https://youtu.be/ON7hpgJRCic

     

    Thanks!

suparnababu8's avatar
suparnababu8
Super User
1 year ago

Hi RosG 

 

Connecting from Power BI Desktop to Azure SQL databases using Entra ID (formerly Azure AD) is indeed possible. Here are the steps and best practices to ensure a secure connection using AD accounts:

Connecting Power BI Desktop to Azure SQL Database Using Entra ID

  1. Open Power BI Desktop:

    • Go to Home > Get Data > Azure > Azure SQL Database.

  2. Enter Server and Database Information:

    • Provide the Server name and Database name.

  3. Authentication Method:

    • Select Microsoft Entra ID (formerly Azure AD) for authentication.
    • Ensure you are signed in with the appropriate AD account.

  4. Firewall Configuration:

    • Ensure that your Azure SQL Database firewall settings allow access from Power BI Desktop. You might need to add your client IP address to the allowed list.

Best Practices for Security

  1. Use Managed Identities:

    • If possible, use managed identities for Azure resources to authenticate to Azure SQL Database. This approach eliminates the need to manage credentials manually.

  2. Enable Single Sign-On (SSO):

  3. Use Private Endpoints:

    • Configure private endpoints for your Azure SQL Database to ensure that traffic between your Power BI service and the database remains within the Azure network.

Alternative Approaches

  1. Paginated Reports:

    • While paginated reports require users to sign in, you can use Power BI Embedded to embed these reports in SharePoint or Teams. This approach provides a seamless experience without requiring additional sign-ins.

  2. Power BI Service:

    • If direct connection from Power BI service to Azure SQL Database is not feasible, consider using an On-premises Data Gateway. This allows you to connect securely to your database and run stored procedures.

If you need additional information pls go through below links

https://learn.microsoft.com/en-us/power-bi/connect-data/service-azure-sql-database-with-direct-connect

https://community.fabric.microsoft.com/t5/Desktop/Connect-to-Entra-ID-data/td-p/3516002

https://youtu.be/ON7hpgJRCic

 

Thanks!