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.
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.
You'll learn how to retrieve data from a variety of data sources, including Microsoft Excel, relational databases, and NoSQL data stores. You'll also learn how to improve performance while retrieving data.
Demonstrate methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Microsoft Power BI.