cancel
Showing results for 
Search instead for 
Did you mean: 
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"

 

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

gboreki
Microsoft
Microsoft

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?

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.


@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


 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.