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.
   
   

   

   
   
   

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

   

   
   
   

4. Enter database server:
   
   

   

   
   
   

5. Specify database authentication method:
   
   

   

   
   
   

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

   

   
   
   

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

   

   
   
   

8. Finish and test connection:
   
   

   

   
   
   

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

Reference:

• https://github.com/mkleehammer/pyodbc/wiki/Connecting-to-SQL-Server-from-Windows