---
title: "Brantial in Data Studio and Looker Studio: Setup"
description: "Open the ready-made Data Studio (formerly Looker Studio) report, or pull Brantial data into Google Sheets, Power BI and your own scripts with one key."
source_url: "https://brantial.ai/help/data-studio/"
lang: "en"
updated: "2026-10-23T00:00:00.000Z"
---

Help

# Brantial data in Data Studio, Google Sheets and Power BI

Open the ready-made Data Studio (formerly Looker Studio) report, or pull Brantial data into Google Sheets, Power BI and your own scripts with one key.

Updated October 23, 2026

Your Brantial data can go into the reporting tools you already use. A ready-made **Data Studio** report (formerly Looker Studio) shows your AI visibility, competitors, prompts and cited sites, and updates itself. The same key also feeds **Google Sheets**, **Power BI** and your own scripts. Setup takes about five minutes.

## Before you start

- **The data API is part of the Growth and Enterprise plans.** On other plans the card shows **See plans** instead of a key.
- **Verify your email address** first; Brantial asks for it before it creates a key.
- One key reads every project you own or belong to, and nothing else. It cannot change anything in Brantial.

## Create a key

1. In Brantial, go to **Settings** and open the **Account** tab. Scroll to **Data Studio & data API**.
2. Click **Create a key**, then **Copy**. Brantial shows a key only once, so keep it somewhere safe until you have pasted it.

![The Data Studio and data API card in Brantial with a new key, the three Data Studio steps and an Open report button](https://brantial.ai/images/help/data-studio/en/1-key-and-report.webp)

The key is blurred here, and the project is an example.

A key works for one year. The card shows when it expires and when it was last used.

## Open the ready-made report in Data Studio

1. In the same card, click **Open report** next to the project you want (or **Open the ready-made report** if you have one project). Data Studio opens a copy of the Brantial report.
2. Data Studio asks you to authorize the Brantial connector to see the whole report. Click **Authorize** and allow access with your Google account.
3. Paste your Brantial key into the **Key** field and click **Submit**. Never type your Google password there.

![Data Studio's connector window with the Brantial connector authorized and an empty Key field with Submit](https://brantial.ai/images/help/data-studio/en/2-authorize-key.webp)

4. The report fills with your project’s data. Click **Save and share** to keep your copy. It stays private to you until you share it.

If the report keeps loading after you paste the key, refresh the page once.

Data Studio shows a note that community connectors are not reviewed by Google. That note appears for every community connector, including Brantial’s.

## What the report contains

The report reads three tables. Each row is one day, so the figures add up over any date range you pick.

| Table | What it shows |
| --- | --- |
| **Visibility** | For each AI and each brand: answers, mentions, visibility and average position. **Your visibility** keeps your brand apart. |
| **Prompts** | For each prompt: answers, mentions, visibility and the sentiment of the answers that named your brand. |
| **Sources** | The sites AI cites, with your own site marked. |

To build your own report instead, click **Or build your own with the connector**. Add the connector once for each table you want, and pick the project and the table each time.

## Google Sheets and Power BI

The same card builds a ready address for each project and table.

1. Under **Google Sheets and Power BI**, choose the **Project** and the **Table**.
2. Copy the line you need.

![The Google Sheets and Power BI part of the card, with a project and table picker, an IMPORTDATA formula and a Power BI address](https://brantial.ai/images/help/data-studio/en/4-sheets-power-bi.webp)

**Google Sheets:** paste the formula into cell A1 of an empty sheet. Sheets refreshes it about once an hour.

**Power BI:** in Power BI Desktop choose **Get data → Web**, paste the address and load it. For scheduled refresh in the Power BI service, set the data source credentials to **Anonymous**; the key in the address does the signing in.

Both return the last 30 days. For other dates, add `start=YYYY-MM-DD&end=YYYY-MM-DD` to the address. One request covers up to 400 days.

> **Keep the formula and the address private.** They contain your key, so anyone who sees them can read this data. Share the sheet or report with care, and revoke the key to cut off access.

If you created the key earlier and no longer have it, the address shows `YOUR_KEY`. Create a new key, or replace `YOUR_KEY` with the key you saved.

## Your own scripts

The data API returns daily counts per AI as JSON, or as CSV with `format=csv`. Send the key as a Bearer token:

```
curl -H "Authorization: Bearer YOUR_KEY" \
  "https://app.brantial.ai/api/v1/projects"
```

| Request | Returns |
| --- | --- |
| `GET /api/v1/projects` | The projects your key can read, with their ids |
| `GET /api/v1/projects/{id}/visibility` | The Visibility table |
| `GET /api/v1/projects/{id}/prompts` | The Prompts table |
| `GET /api/v1/projects/{id}/sources` | The Sources table |

Add `start` and `end` (YYYY-MM-DD) for a date range, or get the last 30 days. Tools that cannot send headers may pass the key as `api_key` in the address of a GET request.

## Replace or revoke a key

- **Create a new key** replaces the current one. Reports, sheets and scripts that use the old key stop updating until you give them the new one.
- **Revoke** turns the key off at once.
- To give an existing Data Studio copy the new key, edit its Brantial data sources and enter the new key when Data Studio asks, or open the ready-made report again from Brantial.

## Troubleshooting

### The report keeps loading after I paste the key

Refresh the page once. The connector has your key by then, and the report fills.

### Charts say “This action is unauthorized”

The key in use cannot read this project. This happens when someone opens a report copy that was set up with another person’s key. Open the ready-made report from your own Brantial account and use your own key.

### Charts stopped updating

The key was revoked or replaced, or it expired after a year. Create a new key and give it to the report, as described under Replace or revoke a key.

### The card shows “See plans” instead of a key

Your plan does not include the data API. It is part of the Growth and Enterprise plans.

### Sheets shows an error instead of data

- Check that the key in the formula is current; a revoked or replaced key stops working.
- Check that the formula starts with `=IMPORTDATA(` and that the address is in quotes.
- Sheets fetches the address again about once an hour, so a fix can take a while to show.

### Power BI refuses to refresh in the service

Set the data source credentials to **Anonymous** in the dataset settings. The key in the address is the sign-in.

### The API answers 401 or 403

- 401: the key is missing, wrong, expired or revoked.
- 403 with a message about plans: the project’s plan does not include the data API.
- 403 with another message: the account no longer has access to the project’s analysis, for example after a subscription ended.

## What the key can see

- Daily counts for the projects you own or belong to: visibility, mentions, positions, prompts, sentiment and cited sites.
- It cannot read other customers’ data, your account details or the AI answers themselves.
- It cannot change anything in Brantial.
