Choosing the Right API
- To connect to Microsoft Power BI, use the DAX API
- To connect to Microsoft Excel, use Cube Cloud for Excel
- To connect to Google Sheets, use Cube Cloud for Sheets
- To connect to AI assistants, use the Model Context Protocol (MCP) server
- For internal or self-serve business intelligence, use Semantic Layer Sync if it supports your BI tools. Otherwise, connect via the SQL API directly
- For embedded analytics and real-time analytics, use REST API or GraphQL API. When using the REST API, the JavaScript SDK can simplify integration with your front-end code
See this GitHub issue
for an unofficial, community-maintained client library for Python.
Data modeling
Support for data modeling features differ across APIs, integrations, and visualization tools. Some of the features with partial support are listed below:| Feature | ✅ Supported in |
|---|---|
| Hierarchies | Microsoft Power BI via the DAX API Cube Cloud for Excel Cube Cloud for Sheets Tableau via Semantic Layer Sync Also, supported in Playground |
| Flat folders | Microsoft Power BI via the DAX API Cube Cloud for Excel Cube Cloud for Sheets Tableau via Semantic Layer Sync Apache Superset via Semantic Layer Sync Preset via Semantic Layer Sync Also, supported in Playground |
| Nested folders | Microsoft Power BI via the DAX API |
| Custom time formats | Playground and Workbooks |