Showing results for 
Search instead for 
Did you mean: 
New Member

Power BI RS

Hello everyone.My database size is around 50gb.I am thinking of using Report Server and planning to buy Sql server ee with sa.What else can I need? What else should I know? What problems can I face? Thanks.

Super User
Super User

It depends what business needs. Especially compressed data model size, number of datamodel used concurently, number of users, and which features is required.

E.g. you buy few Power BI Pro or Power BI Premium per user licences in cloud, and it can be success.

Or With MSSSQL EE SA, you can build complex platform based on MSSQL DB, SSIS for ingest, SSAS for large PBI models, and PBI RS for Power BI report. From long term usage and in case of large models and many endusers, it will be much better from cost perspective (but maybe with some feature limitations).


Generally for small or short solution is better use cloud Power BI Pro or Premium. For large and complex solution with many users is best option combine on-prem MSSQL/SSAS/PBI RS solution with cloud Power BI Premium per capacity.

Solution Sage
Solution Sage

A few things:

1. What you need depends on the business need. I am sure there is business reason why you are going with Report Server, but please take a look at the difference between Power BI Service and Report Server here - Comparing Power BI Report Server and the Power BI service

2. I suggest that you go through some basic training on Power BI development process. There are numerous training options available -

3. The problems you face depends on the problems you are trying to solve and the approach you are taking.  For example, if you are trying to setup Email subscriptions Power BI report, that feature is not available yet in Power BI Report Server.

One final suggestion - it might be beneficial to create new posts with more specific questions. This could help attract more focused and insightful responses from the community, ensuring that you receive timely and valuable information.

Thank you!

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.