Connecting Microsoft Power BI to Tealium DataAccess

[#1]

This article shows how to connect your Microsoft Power BI Desktop application to EventDB and AudienceDB in Tealium DataAccess.

In this article:

Table of Contents Placeholder

Create ODBC Data Source

To connect Power BI to DataAccess, an ODBC Data Source connection is required.

To create an ODBC data source in Power BI:

1. Install the Amazon Redshift Driver for Windows
2. Create a system DSN entry for an ODBC connection
   • Be sure to use "System DSN"
3. Your configurations should mimic the following:
   
4. Once the ODBC Data Source has been configured, click the Test button. If the client computer can connect to the Amazon Redshift database, you will see the following message: Connection successful.
5. Close the ODBC configurations.

Connect Microsoft Power BI to Tealium DataAccess

1. Within Power BI, select the Home tab then Get Data (click the icon, not the drop-down)
2. Select Other, then ODBC, then click Connect.
   
3. Choose your Data source name from the drop-down, then click OK.
   
4. A data Navigator will appear, expand the directory structure and select the table you wish to query then click Load.
   
5. Power BI will connect to the data, load the data for modeling, and you'll see columns populate with your attributes.
   

Now you are ready to build reports using Microsoft Power BI on top of Tealium DataAccess.

Troubleshooting

"Server certificate for <cluster name> does not match host name."

First, try to use the full cluster name in the connection settings. If that does not resolve the error, try changing the sslmode setting to "verify-ca" rather than "verify-full". Learn more about Redshift SSL Support.