Forum Discussion
Sharepoint Report RDL Migration to PowerBI Service portal
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 ServerFrom 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 | Microsoft Learn
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
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
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.
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 ServerFrom 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 | Microsoft Learn
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