BI Dashboard Adapter
Execute SQL/MDX queries against DataLens, Superset, Power BI, Tableau, or Visiology.
BI Dashboard Adapter
The BI Dashboard Adapter is a generic query block that lets AACFlow talk to any BI or analytics platform that exposes a query endpoint. It ships with presets for DataLens, Apache Superset, Microsoft Power BI, Tableau, and Visiology.
There is no single public API standard for BI platforms — this block abstracts away the authentication differences so you can point it at any compatible instance.
Setup
- Determine your BI platform instance URL (e.g.
https://datalens.company.com). - Obtain credentials for the chosen auth type:
- Basic: username and password.
- Bearer Token: a personal access token or service-account token.
- API Key: platform-specific API key.
- Custom Header: header name and value.
- In AACFlow, add a BI Dashboard Adapter block, select the BI Platform preset, enter the base URL, choose the auth type, and paste the credential.
Consult your BI platform's documentation for credential setup:
- DataLens: https://cloud.yandex.ru/docs/datalens/
- Apache Superset: https://superset.apache.org/docs/
- Power BI REST API: https://learn.microsoft.com/power-bi/developer/embedded/rest-api-overview
- Tableau REST API: https://help.tableau.com/current/api/rest_api/en-us/REST/rest_api.htm
- Visiology: https://visiology.pro/
Operations
| Operation | Description |
|---|---|
bi_query | Execute a SQL, MDX, or cube/field query against the selected BI platform and return the result set. |
Example workflow
Use a schedule trigger to run a daily SQL query against your DataLens instance, pipe the result to an AI block to generate a natural-language summary, and post the summary to a Slack channel.
Links
- Block source: apps/aacflow/blocks/blocks/bi_adapter.ts