PBI connection to MS SQL using JDBC connection string

Hi, Anonymous 

To connect from Power BI to MS SQL server using AD-ENT login and IAM password, you need to use the Microsoft ODBC Driver 13 or later. This driver supports Azure Active Directory (AAD) authentication, which is required for AD-ENT login and IAM password.

Here are the steps to follow:

• 1. Download and install the Microsoft ODBC Driver 13 or later on your computer.
• 2. In Power BI Desktop, on the Home tab, select Get data > ODBC.
• 3.In the From ODBC dialog box, select the DSN (Data Source Name) that corresponds to your SQL server database, or enter a connection string manually.
• 4. In the SQL Server Authentication dialog box, select Azure Active Directory - Password as the authentication method, and enter your AD-ENT login and IAM password.
• 5.Select Connect to access your SQL server database.

You can also use a JDBC connection string to connect from Power BI to MS SQL server2, but you need to make sure the Data Connectivity mode is set to Import.

Connect from Power BI to Azure SQL Database using AAD authentication - Microsoft Community Hub

Tutorial: Connect to on-premises data in SQL Server - Power BI | Microsoft Learn

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.