microsoft / microsoft/sql-server-samples

Mobile and PBI report migration

Open
#1,018 0 comments 0 reactions 0 assignees View on GitHub

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

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.