Forum Discussion
Best practise architecture
Hi Anonymous,
With one P1 instance, you can run the Power BI Report Server software itself on up to 8 cores on-premises; that could be one report server on an 8-core machine, or two scale-out report servers on two 4-core machines. Via the “SQL Server Technology” use right, you can run SQL Server Standard on any number of cores, same machine or a different one, solely to store the report server database. (Alternatively, you can bring your own SQL Server license and use the database engine for whatever you like.)
Regarding report server database requirements, see: https://docs.microsoft.com/en-us/power-bi/report-server/system-requirements#database-server-version-requirements
Best Regards,
Qiuyun Yu
Hi Anonymous,
1. To install the on-premise data gateway, the machine needs to meet requirements listed in this article: https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem.
2. The Power BI Premium P1 8 cores are devided to 4 backend cores and 4 frontend cores, for more infomration, see: https://docs.microsoft.com/en-us/power-bi/service-premium#capacity-tiers
Best Regards,
Qiuyun Yu
Thanks for your answer Qiuyun Yu. So i have to set up the Reportserver itself with 4 cores and the SQL server reporting database server with 4 cores also?
Besides, im still wondering - and documentation says nothing about it - is where do I have to install the Reporting databases.. Its an architectural question. Is it OK to put them on a SQL Server with multiple instances already on it, or is het better to create a whole new sql server, dedicated for the Reporting databases? Or is that 'overkill'?
Hi Anonymous,
With one P1 instance, you can run the Power BI Report Server software itself on up to 8 cores on-premises; that could be one report server on an 8-core machine, or two scale-out report servers on two 4-core machines. Via the “SQL Server Technology” use right, you can run SQL Server Standard on any number of cores, same machine or a different one, solely to store the report server database. (Alternatively, you can bring your own SQL Server license and use the database engine for whatever you like.)
Regarding report server database requirements, see: https://docs.microsoft.com/en-us/power-bi/report-server/system-requirements#database-server-version-requirements
Best Regards,
Qiuyun Yu