Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
SteiniJonsson
Frequent Visitor

Unable to upload .xlsm

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 

 


I have added the extension to the TrustedFileFormat and AllowedResourceExtensionsForUpload sections of the configuration but still no luck.
AllowedResourceExtensionsForUpload: *,*.xml,*.xsd,*.xsl,*.png,*.gif,*.jpg,*.tif,*.jpeg,*.tiff,*.bmp,*.pdf,*.svg,*.rtf,*.txt,*.doc,*.docx,*.pps,*.ppt,*.pptx,*.xlsm
TrustedFileFormat: jpg, jpeg, jpe, wav, bmp, pdf, img, gif, json, mp4, web, png, xlsm
 
Uploading the file to a previous version (Version 1.11.7815.26414 (May 2021)) is not an issue.
 
Has anyone else had this issue or do you have a solution for me?
 
Best regards,
Steini
1 ACCEPTED SOLUTION
Petebro
Employee
Employee

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. 

View solution in original post

4 REPLIES 4
Petebro
Employee
Employee

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.

 

SteiniJonsson
Frequent Visitor

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.

 

V-pazhen-msft
Community Support
Community Support

@SteiniJonsson 

Restart the server, reinstall report server or repair with the installer. I have no problem with the Sept version.

 

sept xlsm.PNG

 

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.