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
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.