Power BI Licensing – Cost Forecast Guide

The other day, one of my enterprise customers asked me if there were any guides or documentation to forecast the cost for Power BI service licensing (Pro and Premium) for 3 years based on user growth. I did mention that we can use the official Power BI Premium calculator to calculate it for each year and then use the sum. However, after the call, I took this as an opportunity to show the customer how versatile Power BI is, and decided to create a report for this customer’s particular need.


I thought it might be useful for some enterprise customers to see what the total cost is going to be for 3 years, and decided to share it here. You can use this guide to see some of the additional information like:-

  1. Forecast the growth in % for Pro, Frequent and Occasional users
  2. Get the total cost for 3 years based on the growth
  3. See the per user cost for each year
  4. Also, see the estimated utilization of the last Premium node, which will give you a good idea on whether you are close to upgrading or not

That said, the report is built using the current (as of 3/12/2018) formulas for the Power BI Premium calculator (if it changes, I will try my best to keep it up-to-date) and it might be a good idea to double check your numbers against the original Premium calculator too. Without further ado, the report is given below, feel free to explore.

As always, let me know your feedback or if you have any questions on the same.

Posted by SQLJason


Thomas LeBlanc

Thanks Jason, that is nice!!!

Aleksandar Boshevski

Good job, this is very useful

Thanks Jason.. It is useful…

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.