cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jlj
Frequent Visitor

How to license splitting Power BI report server

Hi,

We current have a single server SQL Server Enterprise Edition running SQL Server, SSAS and PowerBI in a 2 server AG cluster.

The business wants to start moving reports from a different system to reporting services, so its not going to be feasible to continue running everything on a single server.

My understanding is that if I split the PowerBI Report Server to its own server, it will mean we will need another Enterprise Edition license for the server.

We do not want any cloud functionality so I believe the other licensing option is not the way to go.

Would it be feasible to split the SQLServer service into its own server using the SQL Server Standard Edition instead, and having it in an AG cluster. 

Then Power BI and SSAS services will run on the existing Enterprise license on a separate AG cluster.

Does this make sense? Apologies if I am using the wrong terminology, hopefully I am still able to convey what I am trying to do.

TLDR

Running a single server with SSIS, SSAS, SSRS & Power BI.

Need to split things up accomodate increased usage, need advise on most cost effective and effective way to achive this.

If things go well, may require additional report servers so scale out needs to be taken into account.

Any advise would be appreciated.

Thanks 

 

 

 

 

2 REPLIES 2
jlj
Frequent Visitor

Does not look like the poster got an answer.

 

v-luwang-msft
Community Support
Community Support

Hi @jlj ,

refer the following article ,and check if it is helpful:

https://community.powerbi.com/t5/Desktop/Power-BI-Report-Server-without-SQL-Database/m-p/2222085 

 

 


Best Regards

Lucien

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.