SSRS report migration to Power BI

[ajaykumar_k]

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?

[ajaykumar_k]

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"

 

[gboreki]

@ajaykumar_k Rs.exe cannot be used to Migrate to powerbi.com. Please take a look at this tool instead:

https://github.com/microsoft/RdlMigration

[meddojeddo]

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... 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-scrip...

[pbiforum123]

I believe RdlMigration is free of cost for you use. Correct me if I am wrong.

[meddojeddo]

Yes, it is free.

[gboreki]

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]

Do we have any video explaining how this is done? Migrating from SSRS to Power BI service using RDLMigration?

[gboreki]

Hi @Karthik_Ram,

Yes, you can check this link which was done by Guy in the Cube https://youtu.be/_VaBzheAgxY 

Thanks

-gboreki

[pbiforum123]

Thanks a lot for sharing. I have already seen this video before.

It does not show about how to call the .rdl files to the Power BI Report Server-Browse-Paginated Reports. 

I think we need used Get Data option to get the .rdl files one by one. Please correct me if I am wrong. 

Once we get the .rdl files in the paginated reports and convert it into pbix files how the backend things are taken care like dataset, refresh frequency and etc... Please let me know the details...

If you have step by step methods written to migrate the .rdl files to Power BI please let me know.

---

@gboreki wrote:

Hi @Karthik_Ram,

Yes, you can check this link which was done by Guy in the Cube https://youtu.be/_VaBzheAgxY 

Thanks

-gboreki

---

---

@gboreki wrote:

Hi @Karthik_Ram,

Yes, you can check this link which was done by Guy in the Cube https://youtu.be/_VaBzheAgxY 

Thanks

-gboreki

---