Skip to main content
cancel
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

Reply
Aydan
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.

3 REPLIES 3
josef78
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.

Shahfaisal
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 - https://learn.microsoft.com/en-us/training/powerplatform/power-bi?WT.mc_id=powerbi_landingpage-marke...

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

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.