Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Ketevann
Helper I
Helper I

Power BI on Premise No Cloud

Hello, 

Can someone help me with Power BI on-premise ? 

Is it possible to have POWER BI on-premise?

I need to activete on-premise option. Should I buy Power BI Premium Per Capacity or Per User?

And also does Per Capacity license include unlimited users ?  

 

Thank you

1 ACCEPTED SOLUTION

Depends on overall architecture, if you plan you Power BI Report Server (PBIRS) alone (with import mode or direct query), or in combination with SQL Server Analysis Services (SSAS) for dedicated tabular models (with import, direct query and live connection mode).

 

There are functional differences and sizing differences.

PBIRS alone is functionally near to Power BI Pro,

PBIRS alone sizing limits are little better than Power BI Pro limits,

PBIRS+SSAS is functionally near to Power BI Premium,

PBIRS+SSAS sizing limits are bettter than Power BI Premium.

 

Generally, with PBIRS+SSAS, there is no real limit for number of consumer users, model size, number of processing, and performance is limited by licenced CPU cores (with Power BI Premium, is there limit for model size, number of processing, and performance is also limited by licenced CPU cores. But from functional/feature is better Power BI Premium (thanks MS's cloud first strategy).

 

Some functional compare is here:Comparing Power BI Report Server and the Power BI service - Power BI | Microsoft Learn

View solution in original post

4 REPLIES 4
josef78
Memorable Member
Memorable Member

Yes, you can have Power BI on-premies (Power BI Report Server), but feature set is little different.

 

There are two licencing options (both is based on number of CPU/cores):

-Is included in Power BI Premium (per capacity), at least for 8cores (Power BI Premium P1 node), mothly based subscription

-Or is included in SQL Server Enterprise Edition with Software Assurance, at least for 4cores and for 3year.

@josef78 
Thank you so much for your response. 
Can you please  help me to understand what are the differences?  (or may be you have link  to find out  this information), please.  

Depends on overall architecture, if you plan you Power BI Report Server (PBIRS) alone (with import mode or direct query), or in combination with SQL Server Analysis Services (SSAS) for dedicated tabular models (with import, direct query and live connection mode).

 

There are functional differences and sizing differences.

PBIRS alone is functionally near to Power BI Pro,

PBIRS alone sizing limits are little better than Power BI Pro limits,

PBIRS+SSAS is functionally near to Power BI Premium,

PBIRS+SSAS sizing limits are bettter than Power BI Premium.

 

Generally, with PBIRS+SSAS, there is no real limit for number of consumer users, model size, number of processing, and performance is limited by licenced CPU cores (with Power BI Premium, is there limit for model size, number of processing, and performance is also limited by licenced CPU cores. But from functional/feature is better Power BI Premium (thanks MS's cloud first strategy).

 

Some functional compare is here:Comparing Power BI Report Server and the Power BI service - Power BI | Microsoft Learn

@josef78  You are amazing. 

 

Thank you so much.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.