Forum Discussion
SSRS report migration to Power BI
Hi, I am looking for migration from SSRS report to Power BI using RDL tool.If any one has done this before,please provide some details and how much time it will take to migrate one report?
9 Replies
- AnonymousNot applicable
Are you looking for publishing RDL reports from a Reporting Services Service to Powerbi Service Paginated reports? It largely depends on which features you use. If there is parity between the features you are using in your report you can use RdlMigration from github and it will tweak and upload directly to powerbi:
https://github.com/microsoft/RdlMigration
Thanks
-Boreki
- Karthik_Ram
Helper II
Do we have any video explaining how this is done? Migrating from SSRS to Power BI service using RDLMigration?
- AnonymousNot applicable
Hi Karthik_Ram,
Yes, you can check this link which was done by Guy in the Cube https://youtu.be/_VaBzheAgxY
Thanks
-gboreki
- AnonymousNot applicable
I was able to migrate the reports using by using the rs.exe script. You basically just need to download the ssrs_migration.rss file from github: https://github.com/Microsoft/sql-server-samples/tree/master/samples/features/reporting-services/ssrs-migration-rss and place it in your SQL Server Reporting Services Shared Tools folder. Then using command prompt nagivate to that folder and run rs.exe and run the script. This process will copy over all objects and security roles from the SSRS Server to the Power BI Report Server.
Here is a video that guides you through the process: https://www.youtube.com/watch?v=ilQopSoAVEE
And here is the documentation: https://docs.microsoft.com/en-us/sql/reporting-services/tools/sample-reporting-services-rs-exe-script-to-copy-content-between-report-servers?view=sql-server-ver15
- pbiforum123
Post Patron
I believe RdlMigration is free of cost for you use. Correct me if I am wrong.
- AnonymousNot applicable
Yes, it is free.
- ajaykumar_kNew Member
Hi,
I am using RS.exe for the SSRS to power BI (Pro Version) migration but getting below error:
"The underlying connection was closed: An unexpected error occurred on a send."
Used Command:
rs.exe -i ssrs_migration.rss -e Mgmt2010 -s http://*************** -v f="/Development Only" -v ts="https://app.powerbi.com" -v tu="*************" -v tp="**************" -v tf="/ReportMigration"
- AnonymousNot applicable
ajaykumar_k Rs.exe cannot be used to Migrate to powerbi.com. Please take a look at this tool instead: