Connect a Power BI integration

In this guide we will go through the steps to connect to a Power BI integration on the Tekst App.

Setup

Step 1: Navigate to "Integrations".

On the Tekst platform, locate and click on the "Integrations" option. This is typically found in the bottom navigation menu.

Step 2: Add a Power BI Integration

Click the Connect Integration button in the top-right corner of the Integrations page. The Connect page lists the available integrations (you can filter on the Analytics category). Find "Power BI" and click Connect. If Power BI is not enabled for your organization yet, a message asks you to contact support to enable it.

Step 3: Create a user

Create a username that fulfills the below requirements:

• Contains only lowercase letters.
• Contains no special characters.
• Contains at least 6 characters.
• Is not admin or default.

Then click Connect & Continue.

This process creates a user within your customer-specific Amazon Redshift environment, allowing access to fetch data directly from Power BI.

Tekst then shows the username, the generated password and the connection details. Be sure to securely store the username and password in a password management tool for future use: the password is not shown again after this step. Then check the confirmation box and click Next.

Step 4: Connect to the Tekst datasource in Power BI

Add an Amazon Redshift datasource connector to your Power BI project. Use your username and password to authenticate and following parameters:

• Server URL: the Server URL Tekst shows next to your username and password. It has the form <yourcompany>.bi.tekst.com. You can find it again later on the Settings tab of the integration.

• Database: data

• Port: 5439

Select "Public" as the schema and add the "datasources" and "threads" tables to your environment.

If you have an issue following this guide or have any other questions, please submit a request or send your question to support@tekst.com.