topic Re: What needed for using PBI Report Server in production environment in Report Server

What needed for using PBI Report Server in production environment

Gianluca88 — Wed, 02 Nov 2022 08:32:17 GMT

Hi all,

just a theoretical question. I 'm wondering about all we need to install and use PBI Report Server on own internal server.

At the moment we use in a development enviornment:

a) a licence of SQL Server download by an MSDN subscription

b) PBI Report Server as 'Developer' mode.

The question is: what are the necessary ingredients to move PBI RS from a development environment to production one?

thanks,

Re: What needed for using PBI Report Server in production environment

v-luwang-msft — Thu, 03 Nov 2022 09:16:57 GMT

Hi Gianluca88 ，

You may need to GET and PATCH the data sources for a deployed PBIX using the REST API /PowerBIReports({Id})/DataSources

There's nothing in the SSRS PowerShell library to support this directly. You would need to create your own function/code.

refer:

https://community.powerbi.com/t5/Report-Server/Power-Bi-report-deployment-to-Production/m-p/662197

Best Regards

Lucien

Re: What needed for using PBI Report Server in production environment

Gianluca88 — Thu, 03 Nov 2022 09:41:41 GMT

Hi v-luwang-msft ,

thanks for your answer. Another question regarding on licensing theme.

When we will decide to install PBI Report Server for production purpose and using just our internal machines, is it enough to have a licence key only for PBIRS or do we need also a licence key for SQL Server?

My question is raised from the fact that installing SQL Server turns out to be a necessary prerequisite before installing PBIRS.

Thanks,

Re: What needed for using PBI Report Server in production environment

josef78 — Fri, 04 Nov 2022 11:03:27 GMT

You will need licenced for both components:

-Power BI Report Server

-SQL Server DB

For Power BI Report Server you will need SQL Server Enterprise Edition with SA licence (minimum for 4 core) or Power BI Premium (minimum is 8core).

For SQL server is enough SQL Server Standard Edition without SA.

There more option how to setup enviroment:

-you can install both on single machine (not recommended for production) > you will need only SQL Server EE with SA for number of cores of machine

-you can install on two (or more) machines (recommended)> you will need SQL Server EE with SA (or Power BI Premium) for PBI servers, and SQL Server SE for DB machine.

-you can licence entire physical sever with SQL Server EE with SA, and there run multiple virtual machines, some for SQL Server, a few for Power BI Report Server (and later some with SSAS)
-and so on