Release State: General Availability
Products: Power BI Desktop, Power BI Service (Enterprise Gateway), Dataflows in PowerBI.com (Enterprise Gateway), Dataflows in PowerApps.com (Enterprise Gateway), Excel, Flow
Authentication Types Supported: Database (Username/Password), Windows
Some capabilities may be present in one product but not others due to deployment schedules and host-specific capabilities.
By default, Power BI installs an OLE DB driver for SQL Server. However, for optimal performance, we recommend that the customer installs the SQL Server Native Client before using the SQL Server connector. SQL Server Native Client 11.0 and SQL Server Native Client 10.0 are both supported in the latest version.
- DirectQuery (Power BI only, learn more)
- Advanced options
- Command timeout in minutes
- Native SQL statement
- Relationship columns
- Navigate using full hierarchy
- SQL Server failover support
Connect to SQL Server database
To make the connection, take the following steps:
- From the Power Query Get Data dialog (or Data tab in the Excel ribbon), select Database > SQL Server database.
- In the SQL Server database dialog that appears, provide the name of the server and database (optional). Optionally, you may provide a command timeout and a native query (SQL statement), as well as select whether or not you want to include relationship columns and navigate using full hierarchy. Once you're done, select Connect.
- Select the authentication type and input those credentials in the dialogue when prompted.
If the connection is not encrypted, you'll be prompted with the following dialog.
Select OK to connect to the database by using an unencrypted connection, or follow the instructions to setup encrypted connections to SQL Server.