---
title: Power BI Premium vs Azure Analysis Services
description: Your Power BI data model resides in one of two cloud services; Power BI or Azure Analysis Services. Which will you choose?
image: https://blog.coeo.com/hubfs/javier-allegue-barros-C7B-ExXpOIE-unsplash.png
---

[![](https://www.coeo.com/wp-content/themes/coeo/images/logo.svg)](https://blog.coeo.com/)

+44 (0)20 3051 3595 | [info@coeo.com](mailto:info@coeo.com) | [Client portal login](https://my.coeo.com)

# Power BI Premium vs Azure Analysis Services

# The Coeo Blog

![Andy Jones](https://blog.coeo.com/hubfs/Profile%20photos/AndyCircle.jpg)

Your Power BI data model resides in one of two cloud services:

- Power BI, or
- Azure Analysis Services.

***Which will you choose? Read on....***

![javier-allegue-barros-C7B-ExXpOIE-unsplash](https://blog.coeo.com/hs-fs/hubfs/javier-allegue-barros-C7B-ExXpOIE-unsplash.png?width=700&name=javier-allegue-barros-C7B-ExXpOIE-unsplash.png)

You licence Power BI via:

- Power BI Pro, or
- Power BI Premium.

Therefore, you have three choices for your data model:

1. Power BI (Pro licensing)
2. Power BI (Premium licensing)
3. Azure Analysis Services

So far, so good?

You must ***answer a series of questions*** to select the best option for you and your customers.

## Q1: Resources

A Power BI Pro licence without Premium has the following limits:

- 1 GB per dataset
- 10 GB per user (all datasets)
- Eight refreshes per day

You encapsulate all data sources within a Power BI PBIX file to a single dataset when publishing to the Power BI cloud service. If you haven’t purchased Power BI Premium, that dataset can be ***1 GB maximum***. The 1 GB is after compression by the Power BI in-memory engine, so your source data might be significantly larger than 1 GB.

***Are those limits acceptable for you? Write down your answer and move on.***

## Q2: Premium Features

Resources is only one reason you might choose Power BI Premium. Purchasing Premium unlocks additional features that might be a powerful incentive for you:

- Paginated reports
- Multi-region in Azure
- Incremental refresh
- Allocate dedicated resources
- Tools to monitor performance and resource consumption
- Power BI report server

***Are any of these features a requirement in your enterprise?***

## Q3: Lift and Shift

***Do you want to lift and shift your existing on-premises Analysis Services tabular model and publish unchanged to the equivalent cloud service?***

## Q4: Cost

Example costs per month for 20 report creators and 100 report consumers are:

- *Pro*: **£900** ($1,198.80)
- *Premium*: **£3,926.60** ($5,194.80)
- *Azure Analysis Services*: **£3,108.95** ($4,162.60)

Explanation:

- Report creators need a Power BI pro licence (£7.50, $9.99) regardless.
- Report consumers are free with Premium, £7.50 ($9.99) with Pro or Azure Analysis Services.
- I based the Azure Analysis Services estimate on a 24x7 S2 instance in North Europe. Your cost will differ as you can scale up, down and pause compute.
- The Premium cost assumes one P1 SKU satisfies your performance needs.

A hidden benefit of Premium is the ***“paginated reports”*** mentioned in the Premium Features section above. Deploying all your paginated reports to Power BI could potentially allow you to decommission your on-premises SQL Server Reporting Services server(s) with the associated cost savings on hardware, licensing, patching, upgrading, HADR and maintenance.

The exact tipping point where Premium is more economical than pro is 503 users based on UK pricing. I would urge you to still consider premium with far fewer users for reasons I will explain below.

***Does your budget allow for Power BI Premium?***

## Decision Time

Follow the decision tree:

![AJPBIvsAAS20200210](https://blog.coeo.com/hs-fs/hubfs/AJPBIvsAAS20200210.jpeg?width=703&name=AJPBIvsAAS20200210.jpeg)

Regardless of the option you choose, always implement proper governance. Avoid data silos and implement a single version of the truth as I have written about before, [the unseen dangers of Self-Service Power BI](https://blog.coeo.com/self-service-power-bi).

We have traditionally recommended Azure Analysis Services for an enterprise data model, but that has changed with recent advances in Power BI premium:

- Large data models give Power BI Premium data size parity with Azure Analysis Services.
- You can report from Power BI datasets in other reports, even across workspaces. This feature allows that all-important single version of the truth mentioned above.
- Use third-party non-Microsoft reporting tools against Power BI datasets via the read XMLA endpoint.
- A read/write XMLA endpoint is on the 2020 Microsoft roadmap to open Power BI up to all third-party tools, such as Visual Studio and monitoring solutions.

My advice now is Power BI Premium if your budget allows. Microsoft’s goal is for Power BI Premium to be a **superset** of Azure Analysis Services. We already see this, with Microsoft releasing the following features exclusively to Power BI:

- Composite models
- Dynamic memory management
- Bring your key

With Power BI Premium, you:

- Have access to all features.
- Future proof your solution, receiving new features first.
- Future proof your solution, allowing large data models tomorrow even if you answered yes to the Pro limits being acceptable today. How much data will your organisation generate in the coming years (hint: a lot).
- As Power BI explodes in popularity within your organisation, you grant report consumers access without asking for more budget.

The correct location of your data model is one decision of many you make when architecting your optimal Power BI solution. Coeo has a proven series of workshops to get your project off on the right track. We would love to help you, so please [get in touch](https://www.coeo.com/contact-us/).

### Subscribe to Email Updates

## Related posts

---

### [Power BI Paginated Reports is now a Pro Feature](https://blog.coeo.com/power-bi-paginated-reports-is-now-a-pro-feature)

### [Building data governance into everyday processes](https://blog.coeo.com/building-data-governance-into-everyday-processes)

### [SQLBits 2022 - Stream Analytics, Power BI & Super Mario](https://blog.coeo.com/sqlbits-2022-stream-analytics-power-bi-super-mario)

### [The New PL-300 Power BI Exam: What Has Changed?](https://blog.coeo.com/the-new-pl-300-power-bi-exam-what-has-changed)

![](https://www.coeo.com/wp-content/uploads/2016/12/logo-invert.png)

+44 (0)20 3051 3595 | info@coeo.com

## Contact Us

By clicking submit below, you consent to allow Coeo to store and process the personal information submitted above to provide you the content requested.

You may unsubscribe from these communications at any time. For more information on how to unsubscribe and our commitment to your privacy, please review our **[Privacy Policy](https://www.coeo.com/privacy/)**.

## Upcoming Events

[See all events](https://www.coeo.com/events/)

#### NOW Building, Thames Valley Park Drive, Reading, RG6 1RB

[![](https://www.coeo.com/wp-content/themes/coeo/images/social-glass.png)](https://www.glassdoor.co.uk/Overview/Working-at-Coeo-EI_IE959052.11,15.htm)[![](https://www.coeo.com/wp-content/themes/coeo/images/social-in.png)](https://www.linkedin.com/company/coeo-ltd)[![](https://www.coeo.com/wp-content/themes/coeo/images/social-twitter.png)](https://twitter.com/CoeoLtd)[![](https://www.coeo.com/wp-content/themes/coeo/images/social-fb.png)](https://www.facebook.com/coeoltd/)

![](https://www.coeo.com/wp-content/themes/coeo/images//menu-icon.png)

![](https://www.coeo.com/wp-content/themes/coeo/images//menu-close.png)

![](https://www.coeo.com/wp-content/uploads/2016/12/logo-invert.png)

+44 (0)20 3051 3595 | [info@coeo.com](mailto:info@coeo.com)

- [Solutions](https://www.coeo.com/solutions/)
- [Next Steps](https://www.coeo.com/next-steps/)
- [Dedicated Support](https://www.coeo.com/dedicated-support/)
- [Case studies](https://www.coeo.com/case-studies/)
- [Technologies](https://www.coeo.com/solutions/technologies/)

- [Industries](https://www.coeo.com/industries/)
- [Finance](https://www.coeo.com/industries/finance/)
- [Retail](https://www.coeo.com/industries/retail/)
- [Technology](https://www.coeo.com/industries/technology/)

- [The Team](https://www.coeo.com/people/)
- [Join Us](https://www.coeo.com/careers/)
- [Graduate Programme](https://www.coeo.com/graduate-programme/)

- [About Coeo](https://www.coeo.com/about-coeo/)
- [The Coeo Blog](https://www.coeo.com/blog/)
- [Contact us](https://www.coeo.com/contact-us/)
- [Privacy Notice](https://www.coeo.com/privacy/)
- [Cookie Policy](https://www.coeo.com/privacy#Cookie_Policy)

- [Events](https://www.coeo.com/events)

Sign up to our newsletter ![go arrow](https://www.coeo.com/wp-content/themes/coeo/images/newsletter-go.png)

 Back to top