Accelerate Data-Driven Decisions with Microsoft Power BI and AtScale

AtScale provides Power BI users high performance, Live Query access to cloud data sources and visibility to a full semantic model.

The Problem

Power BI is an enormously popular business intelligence platform with rich visualization and
reporting capabilities used by large and small organizations. One challenge for the platform has
been in delivering a performant live query experience for users. Power BI users typically rely on
either local “Imports” of cloud data or ”DirectQuery” mode that suffers from rendering-based
performance challenges.

The Solution

AtScale collaborated with Microsoft to introduce native DAX connectivity which enables Power BI
to leverage Live Query connections through AtScale to common cloud data platforms including
Microsoft Azure Synapse, Google BigQuery, Snowflake, Amazon Redshift, and Databricks. This
joint solution ensures high performance rendering on Power BI and highly performant queries to
cloud data. AtScale is the only solution that supports Live Query connectivity to cloud data.

AtScale & Microsoft Power BI & Partners

Key Business Benefits

AtScale helps Power BI customers build world-class business intelligence programs on cloud data
platforms while taking advantage of the full flexibility and capability of Power BI.

exchange icon

Live Query Support

Only solution enabling Live Query access to cloud data sources leveraging native DAX
connectivity to Power BI

three layers icon

Semantic Modeling

Visualize AtScale semantic model within Power BI with consistent view of metrics and
dimensions across organization

line graph icon

Performance Optimization

Optimize end-to-end analytics performance from cloud data platform to visualization

security shield icon

Security and Governance

Extend role-based security and governance policies of source data to analytics

timeline icon

AI/ML Ready

Leverage AtScale with enterprise AI platforms with ability to visualize model outputs in
Power BI

bar and line graph icon

Integrated External Data Sources

Enhance analyses with external data sources by blending enterprise data with third-party cloud data services within the AtScale model


AtScale enables smarter decision-making by accelerating the flow of data-driven insights. The company’s semantic layer platform simplifies, accelerates, and extends business intelligence and data science capabilities for enterprise customers across all industries.

Key Analytics Benefits
  • High performance Live Query access to cloud data.
  • Leverage AtScale semantic model for dimensional analysis
  • Supports security and governance policies on cloud data with query impersonation of Power BI user credentials