topic Re: Paginated Reports in Power BI in Report Server

Paginated Reports in Power BI

LeoDan — Thu, 15 Sep 2022 21:14:18 GMT

Hello,

We're currently developing Power BI dashboards using Power BI Desktop and Power BI Server for hosting. At the same time we have SSRS reports hosted on SSRS server. We now would like to add Power BI paginated reports as it has richer graphic features comparing to SSRS. So I've got questions about Power BI Reports:

1. For hosting, do we need to install separate Power BI Report Server or Power BI Server that currently hosts dashboards can be re-used?

2. For developing reports, can Power BI Desktop be used for paginated reports' creation or additional software needs to be installed?

3. What is file extension for paginated reports - pbix (like Power BI dashboards) or rdl (like SSRS reports)?

4. Can Power BI Reports be hosted by SSRS server?

Appreciate your help.

Re: Paginated Reports in Power BI

d_gosbell — Fri, 16 Sep 2022 02:34:27 GMT

LeoDan wrote:

We now would like to add Power BI paginated reports as it has richer graphic features comparing to SSRS.

This is not true. The paginated reports in Power BI use the same rendering engine as SSRS

LeoDan wrote:

1. For hosting, do we need to install separate Power BI Report Server or Power BI Server that currently hosts dashboards can be re-used?

So there is no separate product for paginated reports. If you have Power BI Report Server installed on-prem you can host both paginated reports and Power BI Desktop reports on it. If you have reports on the cloud service and you have a premium license of some sort you can also host both types of reports on one of those workspaces.

LeoDan wrote:

2. For developing reports, can Power BI Desktop be used for paginated reports' creation or additional software needs to be installed?

No, you cannot use Power BI Desktop. You would normally use Power BI Report Builder

LeoDan wrote:

3. What is file extension for paginated reports - pbix (like Power BI dashboards) or rdl (like SSRS reports)?

paginated reports use the rdl extension

LeoDan wrote:

4. Can Power BI Reports be hosted by SSRS server?

No, but Power BI Report Server is effectively SSRS plus the ability to run pbix reports.

Re: Paginated Reports in Power BI

LeoDan — Fri, 16 Sep 2022 14:09:28 GMT

Thank you for your answers. Regarding richer features, I did not mean graphics display, but programming features - SSRS is very poor on graphics unlike Power BI or Crystal Reports.