undefined

[Manmitha]

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?

[Anonymous · Accepted solution]

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.

[rohit1991]

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:

1. 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.

2. Use Shared Data Sources:

   • Create shared data sources in your Power BI Premium Workspace.
   • Update the RDL to reference these shared sources.

3. Check Tool Settings:

   • Disable embedded data source creation in the migration tool settings (if available).

4. 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.