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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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.

Memorable Member
Memorable Member

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

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors