Edit

Teradata connection type for Power BI paginated reports (Power BI Report Builder)

  • Article

APPLIES TO: Power BI Report Builder Power BI Desktop

To include data from Teradata in your Power BI paginated report, you must have a dataset that is based on a report data source of type Teradata. This built-in data source type is based on the .NET Managed Provider for Teradata data processing extension.

Use the information in this topic to build a data source embedded within your report. For step-by-step instructions, see Create and Modify Embedded Data Sources (Power BI Report Builder).

Connection string

Contact your database administrator for connection information and for the credentials to use to connect to the data source. The following connection string example specifies a Teradata data source on the server specified with an IP address:

data source=<IP Address>

For more connection string examples, see Create data connection strings - Power BI Report Builder.

Credentials

Credentials are required to run queries and preview the report locally.

Once the report is published to the Power BI service, you need to set up a Power BI gateway for your report, to fetch data from your on-premises Teradata data source. To learn more about Power BI gateways, see What is an on-premises data gateway?

For more information, see Create data connection strings - Power BI Report Builder or Specify Credential and Connection Information for Report Data Sources.

Considerations

Before you can connect a Teradata data source, you need to have installed the version of the .NET Data Provider for Teradata that supports retrieving data from Teradata. This data provider must be installed on the same computer as Power BI Report Builder and the machine hosting the Power BI gateway. To learn more about Power BI gateways, see What is an on-premises data gateway?

These sections of the documentation provide in-depth conceptual information about report data, as well as procedural information about how to define, customize, and use parts of a report that are related to data.

Create data connection strings - Power BI Report Builder
Provides information about data connections and data sources.

Report Embedded Datasets and Shared Datasets (Power BI Report Builder)
Provides information about embedded and shared datasets.

Dataset Fields Collection (Power BI Report Builder)
Provides information about the field collection that is generated by the dataset query.

Supported data sources for Power BI paginated reports Provides in-depth information about platform and version support for supported data sources.

Related content