Power BI & Tableau | Genlytic Docs

OData integration requires Growth plan or above. You need an API key with visibility:read and optimize:read scopes.

Genlytic exposes an OData 4.0 feed at https://api.genlytic.app/v1/odata. Power BI and Tableau connect natively — no custom connector or plugin needed.

Available data

Entity set	Path	Data
Visibility	`/v1/odata/visibility`	Scores, delta, engines per snapshot
Prompts	`/v1/odata/prompts`	Prompt text, category, performance
Competitors	`/v1/odata/competitors`	Their SoV vs your SoV per snapshot
Sources	`/v1/odata/sources`	Citation domains, gaps
Actions	`/v1/odata/actions`	Optimize actions + impact scores

Connect from Power BI

Get your API key

Go to Settings → API → + Create API Key. Select scopes visibility:read and optimize:read. Copy the key — shown once only.

Open Power BI Desktop

Click Get data → search OData feed → select it.

Enter the service URL

Paste the base URL:

https://api.genlytic.app/v1/odata

Click OK.

Set authentication

In the authentication dialog:

Choose Web API (not Anonymous)
Key: Authorization
Value: Bearer gly_live_xxxxxxxxxxxxxxxx

Click Connect.

Select tables

Power BI reads $metadata and shows all 5 entity sets as tables. Check the ones you want → Load (or Transform to filter by period first).

Filter by period in Power Query before loading: add a step Table.SelectRows(visibility, each [period] = "30d"), or append ?period=30d to the entity set URL.

Connect from Tableau

Get your API key

Same as Power BI step 1 above.

Open Tableau Desktop

Click Connect → To a Server → OData.

Enter server URL

https://api.genlytic.app/v1/odata

Authentication: Username and Password (Tableau's OData connector uses Basic Auth fields for headers).

Username: Authorization
Password: Bearer gly_live_xxxxxxxxxxxxxxxx

Click Sign In.

Select a sheet

Tableau lists all entity sets. Drag one to the canvas to start building.

Filter by period

All entity sets accept a period query param:

URL	Data
`/v1/odata/visibility?period=7d`	Last 7 days
`/v1/odata/visibility?period=30d`	Last 30 days
`/v1/odata/visibility?period=90d`	Last 90 days

In Power BI, set the URL per table in the OData feed dialog (click Advanced to enter entity-set URLs individually).

Pagination

The OData feed handles pagination automatically. Power BI and Tableau follow @odata.nextLink to load all pages. Page size is capped at 100 rows per request.

Recommended dashboards

AI Visibility Overview (Power BI)

Card visual: latest score from visibility
Line chart: score over createdAt by brandId
Bar chart: competitor theirSov vs mySov
Table: top actions by impactScore

Competitor Intelligence (Tableau)

Line chart: mySov vs theirSov per competitor over time
Bar chart: delta by engine
Filter: period = 30d

Troubleshooting

"401 Unauthorized" → The Authorization header is missing or the API key is wrong. Check format: Bearer gly_live_xxx.

"403 Forbidden" → Key lacks required scope, or workspace is not on Growth plan.

Empty tables → Try period=90d — data only appears for periods where scans ran.

Power BI "couldn't connect" → Use Power BI Desktop (not browser). Service connections to external OData require a gateway.

Next steps

Data Studio — Google Data Studio connector
API Reference — REST endpoints
Authentication — API key setup