MS SQL ODBC driver for Power BI

  1. Download and install Microsoft® ODBC Driver 17 for SQL Server® -  https://www.microsoft.com/en-us/download/details.aspx?id=56567

  2. Open ODBC Data Source administration for 64bit platform, switch to "System DSN" tab.

    image2018-11-20_18-1-1.png

  3. Add a new source, select the installed ODBC Driver 17 for SQL Server.

    image2018-10-12_13-57-37.png

  4. Enter database server:

    image2018-10-12_13-58-35.png

  5. Specify database authentication method:

    image2018-10-12_13-59-42.png

  6. Specify database access:
    Default database name is SQDB6 or SQDB6_DWH. The namedependson selected database deployment scenario.

    image2018-10-12_14-0-27.png

  7. No change:
    You may need to adjust configuration for data encryption.

    image2018-10-12_14-1-15.png   

  8. Finish and test connection:

    image2018-10-12_14-1-44.png

  9. Repeat steps 3 to 8 for 32 bit ODBC Data Source as well, use exactly the same name.


Reference: