Create Vizualizations in Power BI using Vantage
Overview
This guide includes content from both Microsoft and Teradata product documentation.
This article describes the process to connect your Power BI Desktop to Teradata Vantage for creating reports and dramatic visualizations of your data. Power BI supports Teradata Vantage as a data source and can use the underlying data just like any other data source in Power BI Desktop.
Power BI is a collection of software services, applications, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights.
Power BI consists of:
- A Windows desktop application, called Power BI Desktop
- An online SaaS (Software as a Service) service, called the Power BI service
- Power BI mobile apps for Windows, iOS, and Android devices
These three elements—Power BI Desktop, the Power BI service, and the mobile apps—are designed to let people create, share, and consume business insights in the way that serves them, or their role, most effectively.
A fourth element, Power BI Report Server, allows you to publish Power BI reports to an on-premises report server, after creating them in Power BI Desktop.
Power BI Desktop supports Vantage as a 3rd party data source not as a ‘native’ data source. Instead, published reports on Power BI service will need to use the on-premises data gateway component to access Vantage.
This getting started guide will show you how to connect to a Teradata Vantage. Power BI Desktop Teradata connector uses the .NET Data Provider for Teradata. You need to install the driver on computers that use the Power BI Desktop. The .NET Data Provider for Teradata single installation supports both 32-bit or 64-bit Power BI Desktop application.
Prerequisites
You are expected to be familiar with Azure services, Teradata Vantage, and Power BI Desktop.
You will need the following accounts and system.
-
The Power BI Desktop is a free application for Windows. (Power BI Desktop is not available for Macs. You could run it in a virtual machine, such as Parallels or VMware Fusion, or in Apple’s Boot Camp, but that is beyond the scope of this article.)
-
A Teradata Vantage instance with a user and password. The user must have permission to data that can be used by Power BI Desktop. Vantage must be accessible from Power BI Desktop.
노트If you need a test instance of Vantage, you can provision one for free at https://clearscape.teradata.com
Getting Started
Install Power BI Desktop
You can install Power BI Desktop from the Microsoft Store or download the installer and run it directly.