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.
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:
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.
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.
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.
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. In Power BI Desktop
Go to Get Data → OData Feed.
2. Paste the URL
Copy the OData Feed URL from the block and replace
SUA_CHAVEwith your API key.3. Choose the tables
Click OK and select the gold layer tables.
Tableau, Looker Studio, and other tools#
| Block | Paths the screen offers |
|---|---|
| Tableau | a) OData connector (recommended) with the same feed URL; or b) the native connector indicated on screen, with the managed credential configured in Settings. |
| Looker Studio | a) 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#
- Connect BI: BI → Connect BI
Next task#
- OData in Power BI and Excel — the technical guide
- Data governance screen — BI credential per group
- Dashboards screens
- Your datalake screen