Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. 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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
3 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
5 | |
4 | |
4 | |
4 | |
4 |