May 2020 release - single quotes in path cause errors

graymc — Thu, 04 Aug 2022 20:19:59 GMT

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?

Re: May 2020 release - single quotes in path cause errors

d_gosbell — Fri, 05 Aug 2022 06:29:03 GMT

I'm not sure if this has changed recently. But the UI in the May 2022 release blocks me from attempting to create folders with a ' in the name

This would suggest that you might need to consider renaming these folders to remove the apostrophe

Re: May 2020 release - single quotes in path cause errors

graymc — Fri, 05 Aug 2022 12:24:23 GMT

Ah, thanks. I hadn't thought to test that yet. Our current production server blocks those too.

topic Re: May 2020 release - single quotes in path cause errors in Report Server

May 2020 release - single quotes in path cause errors

Re: May 2020 release - single quotes in path cause errors

Re: May 2020 release - single quotes in path cause errors