Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Noting that this is the Power BI Report Server (PBIRS) forum - not PowerBI.com:
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.
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
Noting that this is the Power BI Report Server (PBIRS) forum - not PowerBI.com:
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.
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
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
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
Hi Anuj,
Thanks for the detailed information and comaprison.
Regards,
Jitendra
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
7 | |
5 | |
4 | |
2 | |
2 |
User | Count |
---|---|
12 | |
7 | |
6 | |
2 | |
2 |