Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
ajaykumar_k
New Member

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 9
ajaykumar_k
New 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"

 

Anonymous
Not applicable

@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
Helper IV
Helper IV

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

 

 

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

Yes, it is free.

Anonymous
Not 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

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

Anonymous
Not applicable

Hi @Karthik_Ram,

 

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

 

Thanks

-gboreki

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.


@Anonymous wrote:

Hi @Karthik_Ram,

 

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

 

Thanks

-gboreki



@Anonymous wrote:

Hi @Karthik_Ram,

 

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

 

Thanks

-gboreki


 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.