This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is upgrading! Read all of the details including the timeline and what you can expect. Learn more
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.
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 4 | |
| 2 | |
| 2 | |
| 1 | |
| 1 |