The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
User | Count |
---|---|
5 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
6 | |
4 | |
4 | |
3 | |
2 |