May 2020 release - single quotes in path cause errors
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?