Teradata database
Summary
| Item | Description |
|---|---|
| Release State | General Availability |
| Products | Excel Power BI (Semantic models) Power BI (Dataflows) Fabric (Dataflow Gen2) Power Apps (Dataflows) Dynamics 365 Customer Insights Analysis Services |
| Authentication Types Supported | Database Windows |
| Function Reference Documentation | Teradata.Database |
Note
Some capabilities may be present in one product but not others due to deployment schedules and host-specific capabilities.
Prerequisites
Before you can connect to a Teradata database, you need the .NET Data Provider for Teradata installed on your computer.
Capabilities Supported
- Import
- DirectQuery (Power BI semantic models)
- Advanced options
- Command timeout in minutes
- SQL statement
- Include relationship columns
- Navigate using full hierarchy
Connect to a Teradata database from Power Query Desktop
To make the connection, take the following steps:
Select the Teradata database option from Get Data. More information: Where to get data
Specify the Teradata server to connect to in Server.
If you're connecting from Power BI Desktop, select either the Import or DirectQuery data connectivity mode. The rest of these example steps use the Import data connectivity mode. To learn more about DirectQuery, go to Use DirectQuery in Power BI Desktop.
Select OK.
If this is the first time you're connecting to this Teradata database, select the authentication type you want to use, enter your credentials, and then select Connect. For more information about using and managing authentication, go to Authentication with a data source.
In Navigator, select the data you require, then either select Load to load the data or Transform Data to transform the data.
Connect to a Teradata database from Power Query Online
To make the connection, take the following steps:
Select the Teradata database option in the Choose data source page. More information: Where to get data
Specify the Teradata server to connect to in Server.
Select the name of your on-premises data gateway.
Note
You must select an on-premises data gateway for this connector, whether the Teradata database is on your local network or online.
If this is the first time you're connecting to this Teradata database, select the type of credentials for the connection in Authentication kind. Choose Basic if you plan to use an account that's created in the Teradata database instead of Windows authentication. For more information about using and managing authentication, go to Authentication with a data source.
Enter your credentials.
Select Use Encrypted Connection if you want to use an encrypted connection, or clear the option if you want to use an unencrypted connection.
Select Next to continue.
In Navigator, select the data you require, then select Transform data to transform the data in the Power Query editor.
Connect using advanced options
Power Query provides a set of advanced options that you can add to your query if needed.
The following table lists all of the advanced options you can set in Power Query.
| Advanced option | Description |
|---|---|
| Command timeout in minutes | If your connection lasts longer than 10 minutes (the default timeout), you can enter another value in minutes to keep the connection open longer. |
| SQL statement | For information, go to Import data from a database using native database query. |
| Include relationship columns | If checked, includes columns that might have relationships to other tables. If this box is cleared, you won’t see those columns. |
| Navigate using full hierarchy | If checked, the navigator displays the complete hierarchy of tables in the database you're connecting to. If cleared, the navigator displays only the tables whose columns and rows contain data. |
Once you've selected the advanced options you require, select OK in Power Query Desktop or Next in Power Query Online to connect to your Teradata database.