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.

    images/download/attachments/160480459/image2018-11-20_18-1-1.png



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

    images/download/attachments/160480459/image2018-10-12_13-57-37.png



  4. Enter database server:

    images/download/attachments/160480459/image2018-10-12_13-58-35.png



  5. Specify database authentication method:

    images/download/attachments/160480459/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.

    images/download/attachments/160480459/image2018-10-12_14-0-27.png



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

    images/download/attachments/160480459/image2018-10-12_14-1-15.png



  8. Finish and test connection:

    images/download/attachments/160480459/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: