Request a Demo

Accelerate Data-Driven Decisions with AtScale and Microsoft Power BI

AtScale provides a semantic layer, plus cost and performance optimization for cloud analytics.

Microsoft Power BI is a collection of software services, apps, and connectors that work together to turn unrelated sources of data into coherent, visually immersive, and interactive insights. Power BI lets you easily connect to your data sources, visualize and discover what’s important, and share that with anyone or everyone you want. AtScale provides an analytics semantic layer to Power BI customers to support dimensional modeling of cloud (and multi-cloud) data platforms. The AtScale semantic layer establishes a business-oriented data model for BI and data science users to interact with via Power BI. AtScale ensures consistently fast query performance and optimization of cloud compute and data resources.

The Power of AtScale and Power BI

AtScale brings a powerful semantic layer and dimensional modeling capability to Power BI users, promoting a true self-serve BI program. (The native DAX integration ensures performance for multi-dimensional models, as well as security and governance policy enforcement leveraging impersonation.) AtScale can connect Power BI users to the full range of cloud data sources, optimizing performance and cost and enabling blending of data from disparate cloud services.


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.

The Power BI + AtScale Advantage

  • Semantic Layer Establish a single view of critical business metrics (e.g., revenue, COGs, headcount) and establish common analytics vocabulary across all analyst groups.
  • No-Code Modeling Build sophisticated models across disparate data sources with no SQL. Rapidly iterate models that can be shared across analysis teams.
  • Optimize Cloud Analytics Optimize analytics programs built on cloud infrastructure. Ensure accessibility and performance, manage costs, bridge multi-cloud data. Security and
  • Governance Extend role-based security and governance policies of source data to analytics consumption.
  • AI/ML Ready Leverage AtScale models with data science tools using a simple Python library and manage within your favorite notebooks.
  • Integrate External Data Sources Enhance analyses with external data sources by blending enterprise data with third-party cloud data services within the AtScale model.

Key Benefits

  • Real-time DAX connection from Power BI to AtScale
  • Optimize cost and query performance for cloud data services
  • Business-oriented semantic layer supports analysis consistency and data literacy
  • No-code approach to building business-oriented data models for BI and data science
  • Maintain fine-grained, role-based access policies for Power BI reports

AtScale Enables Seamless Cloud Transformation

Deliver continuous analytics with zero disruption to business users

Adopting Snowflake was the easiest part of our cloud transformation thanks to AtScale. Repointing AtScale from our old environment to our Cloud data warehouse was seamless for end users.

Author Image

Mark Stange-Tregear

VP of Analytics, Rakuten Rewards


AtScale lets organizations make smarter data-driven decisions with its analytics semantic layer that simplifies, accelerates, and extends BI and analytics programs built on cloud data. For more information, visit

More Great Content