topic undefined in Report Server

undefined

Manmitha — Fri, 20 Dec 2024 10:04:14 GMT

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?

Re: undefined

rohit1991 — Fri, 20 Dec 2024 12:28:42 GMT

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.

Re: undefined

Anonymous — Mon, 23 Dec 2024 05:30:22 GMT

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.