cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SteiniJonsson
Regular 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
Microsoft
Microsoft

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
Microsoft
Microsoft

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

I have installed version 15.0.1107.146 ( Version 1.12.7977.29537 in the About window) and the issue is solved.

 

SteiniJonsson
Regular 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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.