Dismiss Notice

Register now to be one of the first members of this SharePoint Community! Click here it just takes seconds!

Dismiss Notice
Welcome Guest from Country Flag

Connect from Power BI to Azure SQL Database using AAD authentication

Discussion in 'Official Microsoft News' started by Beatriz Garcia Roces, Apr 6, 2017.

Thread Status:
Not open for further replies.
  1. Beatriz Garcia Roces

    Beatriz Garcia Roces Guest

    Blog Posts:
    0
    Currently Power BI doesn’t support AAD authentication when connecting to Azure SQL Database, but using Microsoft ODBC Driver 13 it is possible to do it.

    You can download the driver from here (ODBC Driver 13.1) and install it.

    After installing the driver, you can connect to the Azure SQL using ODBC connector.

    [​IMG]

    Select ODBC and introduce the connection string that should have the following format:

    Driver={ODBC Driver 13 for SQL Server};Server=tcp: <Server Name > ,1433;Database=<Database name>;Encrypt=yes;TrustServerCertificate=no;Connection Timeout=30;Authentication=ActiveDirectoryPassword​

    [​IMG]

    You will be requested to introduce the user and password for the database.

    [​IMG]

    You can find more information about AAD authentication and users here.

    Now you are ready to build your report and publish it to the Power BI Service.

    If you want to keep your data updated on the Power BI Service you will need to use the Power BI Gateway.

    For using the Gateway you need to add the Data Source on the Mange Gateways menu.

    [​IMG]

    For the connection string use the same connection string as in the Power BI Desktop file:

    Driver={ODBC Driver 13 for SQL Server};Server=tcp: <Server Name > ,1433;Database= <Database name>;Encrypt=yes;TrustServerCertificate=no;Connection Timeout=30;Authentication=ActiveDirectoryPassword​

    Now you will be able to select the gateway and perform the refresh.



    Beatriz García

    @BeRoces

    Continue reading...
     
Thread Status:
Not open for further replies.

Share This Page

LiveZilla Live Chat Software