Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
Hello everyone!!
I am planning to install Power BI Report Server but I have questions about using SSAS.
Is it a requirement to install SSAS to install Power BI Report Server? Or when is it convenient to have an SSAS instance together with a Power BI Report Server instance?
Thanks!!!
No, you do not need install SSAS instance together with Power BI Report Server.
Power BI Report installation includes internal and hidden SSAS service in special disk-less mode, but you it's fully integrated, do not take care about it (if standard limitations of PBIRS import models are enough for you)
BUT, if you want little more:
-if you need models larger than 1 or 2GB
-if you want partitions and incremental processing
-if you make more reports based on single model
In these cases you need install SSAS instance (and create models in VisualStudio SSDT), but then, please, install SSAS on separated server (not on same server together with PBIRS), and use Power BI reports with live connection to SSAS.
Check out the May 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
4 | |
3 | |
3 | |
2 | |
2 |