Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
After upgrading Power BI Report Server to version 1.12.7936.39665(September 2021) I'm unable to upload .xlsm document to the server.
The error returned is "Uploading or saving files with .xlsm extension is not allowed. Contact your administrator if you have any questions."
Below are entries from the RSPortal log
2021-10-22 09:58:04.2352|INFO|22|Received request POST /api/v2.0/catalogitems| RequestID = s_90891393-e71f-4cd1-8ab5-96edc102f516
2021-10-22 09:58:04.2352|ERROR|22|library|Throwing Microsoft.ReportingServices.Diagnostics.ResourceFileFormatNotAllowedException: , Microsoft.ReportingServices.Diagnostics.ResourceFileFormatNotAllowedException: Uploading or saving files with .xlsm extension is not allowed. Contact your administrator if you have any questions.;| RequestID = s_90891393-e71f-4cd1-8ab5-96edc102f516
2021-10-22 09:58:04.2509|INFO|70|Sending response. Response code <domain>\<username> 400, Elapsed time 0:00:00.0119152| RequestID = s_90891393-e71f-4cd1-8ab5-96edc102f516
2021-10-22 09:58:05.7040|INFO|22|Received request GET /api/v2.0/CatalogItems(Path='/Steini')| RequestID = s_a95929c4-2ad9-4bfe-9250-8cc3a24fcce8
2021-10-22 09:58:05.7196|INFO|71|Sending response. Response code <domain>\<username> 200, Elapsed time 0:00:00.0146411| RequestID = s_a95929c4-2ad9-4bfe-9250-8cc3a24fcce8
2021-10-22 09:58:05.7821|INFO|22|Received request GET /api/v2.0/catalogitems(d5b370eb-16bd-4e60-8d7b-0e6335d6ef09)/Model.Folder/catalogitems/| RequestID = s_d7c1a305-f2fe-452d-9689-40c6316d6e63
2021-10-22 09:58:05.9540|INFO|70|Sending response. Response code <domain>\<username> 200, Elapsed time 0:00:00.1715778| RequestID = s_d7c1a305-f2fe-452d-9689-40c6316d6e63
Solved! Go to Solution.
This was a regression added in September release of Power BI Report Server. We have a fix and will be releasing a patched version of September Report Server in the coming weeks which fixes this and several other reported issues. Appologies for the inconvience.
This was a regression added in September release of Power BI Report Server. We have a fix and will be releasing a patched version of September Report Server in the coming weeks which fixes this and several other reported issues. Appologies for the inconvience.
I have installed version 15.0.1107.146 ( Version 1.12.7977.29537 in the About window) and the issue is solved.
I tried to run repair on my computer but that did not fix the issue. I have two clients who have upgraded PBISSRS to the Septemer version and they both have this error.
As all the instances have Icelandic collation, which might be causing this (that would not be the first time), I will spin up a all-English instance and do some more tests.
I will post the results when we are done.
@SteiniJonsson
Restart the server, reinstall report server or repair with the installer. I have no problem with the Sept version.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.