cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jitendrabi07 Regular Visitor
Regular Visitor

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

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

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
ITGeek555 Regular Visitor
Regular Visitor

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

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.

View solution in original post

AnujMishra_09 Frequent Visitor
Frequent Visitor

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

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

View solution in original post

5 REPLIES 5
ITGeek555 Regular Visitor
Regular Visitor

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

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.

View solution in original post

jitendrabi07 Regular Visitor
Regular Visitor

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

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 Frequent Visitor
Frequent Visitor

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

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 Frequent Visitor
Frequent Visitor

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

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

View solution in original post

jitendrabi07 Regular Visitor
Regular Visitor

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

Hi Anuj,

 

Thanks for the detailed information and comaprison. 

 

Regards,

Jitendra

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 162 members 1,748 guests
Please welcome our newest community members: