Cube, the providers of the leading universal semantic layer platform, is debuting new, expanded integrations with Microsoft Power BI and Microsoft Excel, designed to better meet customers in their Microsoft stacks. These integrations support enterprise data and analytics teams relying on the Microsoft analytics suite, bolstering Cube’s status as a unifier of diverse data sources.
The first of these integrations manifests as the new Data Analysis Expressions (DAX) API for Power BI, an architecture that natively connects Power BI to Cube. The DAX API enables teams to query Cube data models in real time via the DAX API, offering direct access to live data in cloud data warehouses—such as Databricks and Snowflake—from Power BI. This is further strengthened by the power and expressiveness of the DAX query language, according to Cube.
This announcement also introduces the Cube Cloud for Excel Add-in, an integration that connects to governed data with Excel desktop or Excel online. Through a custom interface, users can slice, dice, and pivot, as well as update their analyses from the data source in a single click. Cube Cloud for Excel Add-in aims to eliminate the reliance on manual data exports and snapshots for multidimensional analysis—which often leads to outdated insights, low governance, and inefficiencies, according to Cube.
“Enterprises are rapidly adopting cloud data platforms like Microsoft Azure, Snowflake, and Databricks,” said Artyom Keydunov, CEO and co-founder of Cube. “However, the shift to the cloud has left many organizations without a modern OLAP solution for multidimensional analysis that can integrate with a broad ecosystem of data consumption tools. Today, we are excited to announce our native integrations with Excel and Power BI. With our new DAX API, enterprises can query data live, without extracts, in cloud data warehouses, such as Snowflake and Databricks, directly from Power BI.”
To learn more about Cube’s latest integrations, please visit https://cube.dev/.