microsoft / microsoft/sql-server-samples
Mobile and PBI report migration
Nobody has claimed this yet.
- Dominant language
- PowerShell
- Stars
- 11.2k
- Forks
- 9.1k
- Avg merge
- 2d 7h
- Merged PRs (30d)
- 14
Description
Hi I migrated SSRS from one server (ver. Jan2021) to another (ver. Jan2022). All was fine with rs.exe and migration script. I have only issues with PowerBI (.pbix) and Mobile Reports (.rsmobile) because only .rdl are migrated.
I got this error for every PBI or mobile report:
first phase: retrieve catalog
Folder: /Main/Area/Customer/Customer Editings/contents
(this is OK)
Second step: migration
Migrating Folder: /Main/Area/Customer/Customer Editings/contents ... FAILURE:
System.Web.Services.Protocols.SoapException: The item '/Main/Area/Customer/Customer Editings' cannot be found. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: Th
e item '/Main/Area/Customer/Customer Editings' cannot be found.
at Microsoft.ReportingServices.Library.ReportingService2010Impl.CreateFolder(String Folder, String Parent, Property[] Properties, CatalogItem& ItemInfo)
at Microsoft.ReportingServices.WebServer.ReportingService2010.CreateFolder(String Folder, String Parent, Property[] Properties, CatalogItem& ItemInfo)
it seems that parent folder (really isn't a folder but the PBIX report) isn't retrieved from Catalog.
any idea?
many thanks
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start with the rs.exe migration script and its catalog retrieval and migration steps, then trace the ReportingService2010.CreateFolder call shown in the error. Compare how .rdl items are handled with .pbix and .rsmobile items; done means the migration completes for those report types without the missing-parent-folder error.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- powershell
- Domain
- tooling
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100