Learn how AtScale brings a powerful semantic layer and dimensional modeling capability to
Power BI users, promoting a true self-serve BI program.

The Power of AtScale and Power BI

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.

This brief will explain how 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.

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

Get your free copy

Spoiler Alert!

Enterprises that implement a semantic layer with a live connection to their BI tools, including Microsoft PowerBI, get instant access to their structured and unstructured data. This provides access to data for analysts directly from PowerBI – without extracts and without requiring users to know where the data resides or how it’s formatted.

A ‘Semantic Layer’ – Why Now?

A semantic layer provides business friendly data access wherever the data may lay. Whether its data at rest in a data lake or warehouse, or data that lives behind a SaaS application’s APIs, the semantic layer should hide the physical location and form of the data from consumers.

Data virtualization is a key ingredient of a semantic layer because it presents a “logical” view of the data. By minimizing manual data movement (ETL/ELT), a semantic layer powered by data virtualization improves business agility by removing dependencies on IT and providing fresh, up to date data.

“The growth of data, and increased accessibility of self-service Business Intelligence (BI) tools such as Microsoft’s Power BI, Tableau, and Looker, are creating more concurrent queries against a broad set of data sources.

Compounding this trend is the growing use and capabilities of cloud services, and the evolution of Big Data solutions such as Apache Hadoop and Spark.

Besides these technical trends, more organizations are hiring Chief Data Officers (CDOs) to figure out how to make this new data a competitive differentiator – and, to make smarter data-driven decisions at scale.

The traditional approach of moving and transforming data to meet these needs and power these analytic capabilities is becoming less feasible with each passing requirement…

Andrew Brust


“AtScale’s strong support for a business-friendly semantic layer and its intelligent data virtualization are probably its most compelling features.

Coupled with an easy-to-use web-based design interface, multi cloud support, and strong data source and tool integration, the offering should have wide appeal, especially for organizations wanting to create or enhance a self-service data culture.

In addition, the decoupling between physical infrastructure and logical layer should make AtScale a great fit for data modernization and migration initiatives.”

Yiannis Antoniou


Who should read this brief?

Data-driven leaders and practitioners (e.g., Chief Data Officers, data scientists, business intelligence, and analytics professionals) looking to accelerate analytics for PowerBI.