Azure SQL Data Warehouse
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
Authentication Types Supported: Windows (Power BI Desktop, Excel, online service with gateway), Database (Power BI Desktop, Excel), Microsoft Account (all), Basic (online service)
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 Azure SQL Data Warehouse. However, for optimal performance, we recommend that the customer installs the SQL Server Native Client before using the Azure SQL Data Warehouse 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)
- Advanced options
- Command timeout in minutes
- Native SQL statement
- Relationship columns
- Navigate using full hierarchy
- SQL Server failover support
Connect to Azure SQL Data Warehouse
To make the connection, take the following steps:
Select the Azure SQL Data Warehouse option in the connector selection.
If you're connecting from Power BI desktop or Excel:
In the SQL Server database dialog that appears, provide the name of the server and database (optional).
If you're connecting from Power BI Desktop, select either the Import or DirectQuery data connectivity mode.
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. You can also enable SQL Server failover support. Once you're done, select OK.
If this is the first time you're connecting to this database, select the authentication type, input your credentials, and select the level to apply the authentication settings to. Then select Connect.
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 these instructions to set up encrypted connections to Azure SQL Data Warehouse.
If you're connecting from an online service:
In the Azure SQL Data Warehouse dialog that appears, provide the name of the server and database.
If this is the first time you're connecting to this database, select the authentication kind and input your credentials.
If required, select the name of your on-premises data gateway.
If the connection is not encrypted, clear the Use Encrypted Connection check box.
Select Next to continue.
In Navigator, select the data you require, then either load or transform the data.