Connect to Teradata

• Run Power BI Desktop, which has a yellow icon.

• In the main form of Power BI, click on Get data from other sources.

  

• Search for Teradata database. Click on Teradata database.

• In the window that appears, enter the name or IP address of your Teradata system into the text box. You can choose to Import data into the Power BI data model, or connect directly to the data source using DirectQuery and click OK.

(Click Advanced options to submit hand-crafted SQL statements.)

• Select the Basic authentication method and enter your username and password. Click Connect.

You also have the option of authenticating with an LDAP server. This option is hidden by default.

If you set the environment variable, PBI_EnableTeradataLdap, to true, then the LDAP authentication method will become available.

Note that LDAP is not supported with the on-premises data gateway, which is used for reports that are published to the Power BI service. If you need LDAP authentication and are using the on-premises data gateway, you will need to submit an incident to Microsoft and request support.

Alternatively, you can configure Kerberos-based SSO from Power BI service to on-premise data sources like Teradata.

Once you have connected to the Teradata system, Power BI Desktop remembers the credentials for future connections to the system. You can modify these credentials by going to File > Options and settings > Data source settings.

The Navigator window appears after a successful connection. It displays the data available on the Teradata system. You can select one or more elements to use in Power BI Desktop.

You can preview a table by clicking on its name. If you want to load it into Power BI Desktop, ensure that you click the checkbox next to the table name.

You can Load the selected table, which brings it into Power BI Desktop.

Once the data is loaded, you can perform filtering and transformations.

And of course, you can create visualizations.

You can publish your reports and visualizations by following the steps on Publish semantic models and reports from Power BI Desktop.