Skip to content

Automatic translation — the Portuguese version is the reference. View in Portuguese

Updated on 2026-10-03

Connect BI screen — Excel, Power BI, Looker Studio, and Tableau

The /connect screen — the API base URL, the access key, the five blocks (Power BI, Tableau, Looker Studio, Excel, and REST API), and the three-step Excel wizard — with the literal label of each button. The /excel address leads here.

On this page (7)

Interface inventory: the text here is the text on screen.

Where it is: menu BI → Connect BI (address /connect).

Title Connect BI, subtitle "Use your data in any BI tool or spreadsheet, read-only, via API."

It's for people who already use a tool — finance's Excel, leadership's Power BI — and want it to read the ready-made data from the datalake, without copying spreadsheets by hand. Everything here is Read-only: no external tool changes your data.

Note

/excel is not a separate screen The /excel address leads straight to this screen. The Excel wizard lives in the Excel block, below, since 09/26/2026.

The top of the screen#

The Your data, in any tool box explains what can be read: the Gold layer (ready for consumption) and Silver (intermediate). It includes:

  • API base URL and Your dataset (gold layer), each with Copy;
  • the reminder that you need an API key, with the Manage keys button, which takes you to Settings.
Connect BI screen: the Your data, in any tool box, with the API base URL, the gold layer dataset, Manage keys, and the blocks for each tool

Then come five blocks, all collapsed — click the name to open one: Power BI · Tableau · Looker Studio · Excel · Other tools (REST API).

Connect Excel to your data#

The Excel block ("A PivotTable linked to the feed, refreshed in one click.") has three steps:

  1. Step 1 · Your access key

    Click Generate key for Excel (while running: "Generating...") — or paste into API key a key you already have. The screen warns: "Key created. It won't be shown again", so copy the URL right afterwards.

  2. Step 2 · OData Feed URL

    Copy the URL that appears. It lists all the published tables in your datalake, and you choose which ones to bring in.

  3. Step 3 · In Excel

    Follow the screen's script: Data → Get Data → From Other Sources → From OData Feed, paste the URL and click OK (authentication as Anonymous: the key already goes inside the URL), check the tables, and choose Load To… → PivotTable Report. To refresh later: Data → Refresh All.

Excel block open before generating the key: Step 1 Your access key with Generate key for Excel, Step 2 OData Feed URL still with the SUA_CHAVE placeholder, and the start of Step 3 In Excel

With the key generated, the Step 2 URL comes out ready and gets the This URL is a secret warning: it carries the key, and anyone with the link can read the published data.

Why a key just for Excel? The screen itself answers: "that way you can revoke it later without breaking your other integrations."

The feed URL is a secret

The screen warns: This URL is a secret — it carries your key, and anyone with the link can read all the workspace's published data. Don't send it to a WhatsApp group or paste it into a shared spreadsheet. If it leaks, revoke the key in Settings: the link dies immediately.

Those who prefer the key outside the address use the Power Query: the key goes in the header path, in the Advanced — key outside the URL and connection check section. That's also where $metadata (check) lives, useful when a column doesn't show up in Excel.

The Published tables list shows the available tables (with Filter table...) and each one's URL, to go straight to a table. With none: "No published table yet — run a pipeline up to the Gold or Silver layer and it shows up here."

Connect Power BI#

In the Power BI block ("Via OData Feed (native)."):

  1. 1. In Power BI Desktop

    Go to Get Data → OData Feed.

  2. 2. Paste the URL

    Copy the OData Feed URL from the block and replace SUA_CHAVE with your API key.

  3. 3. Choose the tables

    Click OK and select the gold layer tables.

Tableau, Looker Studio, and other tools#

BlockPaths the screen offers
Tableaua) OData connector (recommended) with the same feed URL; or b) the native connector indicated on screen, with the managed credential configured in Settings.
Looker Studioa) the native connector indicated on screen (recommended, no credential to assemble by hand); or b) Via REST API, with your key.
Other tools (REST API)Any tool that speaks HTTP, with the key in the Authorization: Bearer header. The screen includes the Example — list tables (curl).

Security and cost#

  • Every key is read-only and valid only for your workspace. Each access is recorded in the audit trail.
  • Revoke a key at any time in Settings.
  • The volume of data read by the tools is charged as data usage. In Excel, each page brings up to 1,000 rows — Excel paginates on its own.

Back to the app#

Next task#

Related links