We just upgraded one of our test servers to the May 2020 PBIRS release. After the upgrade, navigating to item paths where the folder has a single quote (apostrophe) in the folder name fails.
Report Server:
Microsoft Power BI Report Server Version 15.0.1108.297
SQL Server:
Microsoft SQL Server 2016 (SP3-CU1-GDR) (KB5015371) - 13.0.7016.1 (X64)
May 21 2022 01:00:03
Copyright (c) Microsoft Corporation
Developer Edition (64-bit) on Windows Server 2012 R2 Standard 6.3 <X64> (Build 9600: )
Issue Example:
Navigating to a path with the folder name "Cashier's Office" fails with an error -
Could not load folder contents
The folder “ecuBIC/Finance/Cashier's Office” does not exist. It could have been renamed, moved, or deleted.
From the RS log files:
2022-08-04 11:23:09.4162|INFO|27|Received request GET /api/v2.0/CatalogItems(Path='/ecuBIC/Finance/Cashier''s%20Office')| RequestID = s_3bd7a21b-1114-4602-bd5b-614bce15fa78
2022-08-04 11:23:09.4162|ERROR|27|library|Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: , Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item '/ecuBIC/Finance/Cashier''s Office' cannot be found.;| RequestID = s_3bd7a21b-1114-4602-bd5b-614bce15fa78
Querying the REST API from Powershell reproduces the issue:
PS> invoke-restmethod "https://xxServer.domainxx/reports/api/v2.0/CatalogItems(path='/ecuBIC/Finance/Cashier''s Office')" -usedefaultcredentials
Invoke-RestMethod: {"error":{"code":"2","message":"The item '/ecuBIC/Finance/Cashier''s Office' cannot be found."}}
I noticed that the "'" was being escaped in the path using another single quote. Removing the escaping character allowed the call to work:
PS> invoke-restmethod "https://xxServer.domainxx/reports/api/v2.0/CatalogItems(path='/ecuBIC/Finance/Cashier's Office')" -usedefaultcredentials
@odata.type : #Model.Folder
Id : dbd53268-0d91-447c-8602-4a9fd53f4ad6
Name : Cashier's Office
Description :
Path : /ecuBIC/Finance/Cashier's Office
Type : Folder
Hidden : False
Size : 0
ModifiedBy : xxxxxxxxxxxxxxxx
ModifiedDate : 4/26/2022 9:23:22 AM
CreatedBy : xxxxxxxxxxxxxxxxxxx
CreatedDate : 5/11/2012 11:49:17 AM
ParentFolderId : 9983e89e-5b09-452f-87c9-a31cd9395ddb
IsFavorite : False
ContentType :
Content :
Roles : {}
This appears to be similar to an issue from 2017:
https://community.powerbi.com/t5/Issues/Apostrophe-in-Folder-Name-Causes-Menu-Failure/idi-p/304933
We do not experience this issue on our current production server: Microsoft Power BI Report Server Version 15.0.1108.159
- Is anyone else experiencing this issue?
- Is this a known issue with the May 2022 release?
