Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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.
Solved! Go to Solution.
@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.
@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.
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.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 10 | |
| 5 | |
| 5 | |
| 4 | |
| 3 |