Sharepoint Report RDL Migration to PowerBI Service portal

[PBUser2025]

Hello,

We are in the process of migrating Sharepoint Report(.RDL) to PowerBI reports which will be published in Power BI service https://app.powerbi.com portal.
Using the Power BI Report converter tool we are converting RDL files to PowerBI reports and publishing to Power BI service https://app.powerbi.com portal.

Please advise if there are efficient and automated way to convert and migrate rdl reports to Power BI report.

We are opening up the rdl file via Report Builder too and deleting the datasource then adding and mapping newly created datasource to datasets on the report. Once datasource is created and mapped to datasets we are publishing the report to PowerBI service.
We automated the datasource creating and mapping using copilot agent.

Some of the rdl files also have subreports linked to the main report. We could not identify any pattern to map subreport to main report before publishing to power bi service portal. Currently, we are converting subreports separately and publishing to Power BI portal.
Once subreport is published we are adding subreports by removing the sub report on rdl then inserting again.

Please advise how we can convert and link main report to subreports on rdl file then publish to Power BI service portal using automated script which will help us save lots of time and efforts.

Thank you for your help

[v-nmadadi-msft]

Hi @PBUser2025 

As we haven’t heard back from you, we wanted to kindly follow up to check if the suggestions  provided by the community members for the issue worked. Please feel free to contact us if you have any further questions.

Thanks and regards

[v-nmadadi-msft]

Hi @PBUser2025 ,

May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.

Thank you

[v-nmadadi-msft]

Hi @PBUser2025 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.

[v-nmadadi-msft]

Hi @PBUser2025 ,
Thanks for reaching out to the Microsoft fabric community forum.

To streamline the publishing process, you can automate it using the Power BI REST API.
Here are the supported operations that are supported for paginated reports:
Reports - REST API (Power BI Power BI REST APIs) | Microsoft Learn
especially check out this particular operation and verify weather that is suitable for your use case
Reports - Update Report Content In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Its key functionality is to update the content of the specified report from the specified workspace with the content of a specified source report.

Additionally check this article which talks about migrating  subreports.

Subreports in Power BI paginated reports - Power BI | Microsoft Learn

I hope this information helps. Please do let us know if you have any further queries.
Thank you

[PBUser2025]

Thank you for reaching out. We are following the below steps for converting the reports from RDL which includes subreports to PowerBI Service:

1. Open the report in Power BI Report Builder.

2. Remove the RDL sharepoint data source and add new datasource

 3. Map datasource to datasets.

4. Ensure reports runs using the new datasource then publish the report to Power BI Service.

Please note: we were able to replace datasource on all the reports using Github copilot but still need to open each repor manually and publish.

Please let us know if we can remove then add new datasource, map the datasource to dataset and publish to powerbi automatically without having to open each report.

For Subreports:

 5. We are opening subreports separately on Power BI Report builder then following simillar steps as above for datasource then publishing to PowerBI Service.

6. Once sub reports are published we are opening the main paginated report and removing the old sub report then adding them back from PowerBI service using Insert subreport option on Report Builder.

We are unable to automated the process of inserting subreports.

Please let us if we can perform steps 5 and 6 via automated process since we have around 300 reports we need to convert.

Again, really appreciate your help and support and our migration Journey.

[v-nmadadi-msft · Accepted solution]

Hi @PBUser2025 ,
Thanks for reaching out to the Microsoft fabric community forum.

This level of automation is not yet possible with Power BI to help with your step 5 and step 6.

Instead you can try this workaround, where you can publish all your .RDL files to SQL Server Reporting Server

From there you can publish all your .rdl files to Fabric workspace.
Publish .rdl files to Power BI from Power BI Report Server and Reporting Services - Power BI | Micro...

Try out this workaround for a few reports and check if you are able to bypass editing the  sub report  part.

I hope this information helps. Please do let us know if you have any further queries.
Thank you