Integrate SSRS Reports from Power BI report server and Power BI reports from Power BI Service

[Anonymous]

Hi,

I want to re-build some of my SSRS reports in Power BI. Can you guys please give your suggestions as what would be the best way to do that?

Earlier I though to pin visual to Power BI but unfortunately all the SSRS reports are in the table form only.

Thanks

Jitendra

[ITGeek555 · Accepted solution]

Noting that this is the Power BI Report Server (PBIRS) forum - not PowerBI.com:

1. Split the reports into two types
   1. Paginated Reports (Report Builder)
      1. reports that must be printed on one or more pages
      2. reports that must be emailed out or users are to subscribe
   2. Analysis Reports (Power BI Desktop (PBID))
      1. reports that are more suited to user interaction
2. Upload the Paginated reports into PBIRS and use them
3. Rebuild the Analysis reports and save to PBIRS

There is no out-of-the-box tool to convert a Report Builder report to a PBID report.

Do not rebuild a Report Builder report to PBID if the report is pages of rows and columns.  PBID does not work well with this layout and you can forget about printing it.

[ITGeek555 · Accepted solution]

Noting that this is the Power BI Report Server (PBIRS) forum - not PowerBI.com:

1. Split the reports into two types
   1. Paginated Reports (Report Builder)
      1. reports that must be printed on one or more pages
      2. reports that must be emailed out or users are to subscribe
   2. Analysis Reports (Power BI Desktop (PBID))
      1. reports that are more suited to user interaction
2. Upload the Paginated reports into PBIRS and use them
3. Rebuild the Analysis reports and save to PBIRS

There is no out-of-the-box tool to convert a Report Builder report to a PBID report.

Do not rebuild a Report Builder report to PBID if the report is pages of rows and columns.  PBID does not work well with this layout and you can forget about printing it.

[Anonymous]

Hi,

Thanks for sharing the very good information and appreciate that.

In the continution to the migration query, I would like to add more to understand the benifits of power bi reports over SSRS reports and if you can highlight the challenges during this migration.  

Thanks

@AnujMishra_09 

[AnujMishra_09]

Hi Jitendra,

Both the tools SSRS and PBI are useful for different requirements:

PBI:

Desktop based as well as cloud hosted.

For visulaization and analysis

Work with structured and unstructured both types of data.

Modelling can be done in tool itself.

Tool is free to use, you need to have PRO license if you want to publish your report in cloud.

Its a self service BI tool.

SSRS:

Usefull for operation reporting

You can create table, matrix and tablix reports and also use limited visuals like graphs, bars and charts.

It works only with structured data.

Need to have SQL server license.

You can't do modelling in this.

You can create paginated reports.

Thanks,

Anuj

[AnujMishra_09 · Accepted solution]

Hi Jitendra,

Please see more on this:

Main missing features

-Subscriptions

-Export to pdf

-Table features (not good enough)

-On Premise

-Data alerts only available in mobile

-Actions

Main cool features

-Ease of development

-No installation

-Cool visualizations

-Analyze with Excel

-Make’s it so much more fun to create reports/dashboards

-More would want to become report developers

-Strong community and uservoice

Mainn challenges:

-Moving from tables and figures to visualisation

-Converting the rdl files directly to .pbix files and editing those for further enhancement. (You can pin it in dashboard in PBI.com and then edit it there)

Hope this helps.

Thanks,

Anuj

[Anonymous]

Hi Anuj,

Thanks for the detailed information and comaprison. 

Regards,

Jitendra