Forum Discussion
undefined
I have used the rdl migration tool to migrate a report from PBIRS to a Power BI paginated report. I can see in the logs that the report is converted( can see the original and converted rdls) but these are not getting uploaded/migrated to my premium workspace and giving the error : FAILED TO UPLOAD : Stock Positions Report RequestId:0d1f623c-da22-4270-900c-cf4b1f84ce83 PaginatedReportAuthoringError.
The issue is because of the shared datasets that are getting converted to embedded.
The tool is creating duplicate embedded datasources, I will again have to manually modify and repoint each dataset to the correct embedded datasource.
Any idea where this is going wrong?
Thank you rohit1991
Hi, Manmitha
According to the documentation, the RDL tool is only responsible for the migration, not the data source settings, and if your report has a shared data source, the RDL migration tool will try to convert the shared data source to an embedded data source. Regardless of whether you have created a corresponding data source, you should specify the correct data source for your report:
Plan to migrate .rdl reports to Power BI - Power BI | Microsoft Learn
This is noted in the documentation, but of course you may encounter your situation when the RDL migration tool tries to create an embedded data source, due to a different environment. The tool was last updated in 2022. So there may be some incompatibility with your current environment.
Releases · microsoft/RdlMigration · GitHub
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Thank you rohit1991
Hi, Manmitha
According to the documentation, the RDL tool is only responsible for the migration, not the data source settings, and if your report has a shared data source, the RDL migration tool will try to convert the shared data source to an embedded data source. Regardless of whether you have created a corresponding data source, you should specify the correct data source for your report:
Plan to migrate .rdl reports to Power BI - Power BI | Microsoft Learn
This is noted in the documentation, but of course you may encounter your situation when the RDL migration tool tries to create an embedded data source, due to a different environment. The tool was last updated in 2022. So there may be some incompatibility with your current environment.
Releases · microsoft/RdlMigration · GitHub
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi , hope this helps:
The issue arises because the RDL Migration Tool converts shared data sources to embedded ones, creating duplicates and breaking dataset references. To resolve:
Clean RDL Files:
- Open the converted RDL in Report Builder.
- Remove duplicate embedded data sources in the <DataSources> section and point all datasets to a single source.
Use Shared Data Sources:
- Create shared data sources in your Power BI Premium Workspace.
- Update the RDL to reference these shared sources.
Check Tool Settings:
- Disable embedded data source creation in the migration tool settings (if available).
Manually Repoint Datasets:
- After uploading, assign datasets in Power BI to correct shared data sources.
By aligning data sources in your workspace and the RDL, the upload should succeed.
