Sharepoint Report RDL Migration to PowerBI Service portal

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.