excel workbook

4 Topics

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
Solved
SteiniJonsson
4 years ago Place Report Server
3.6KViews
0likes
4Comments
Excel Workbook support, Office Online Server, and Windows Server 2019
We have a business need to host Excel workbooks alongside other published Power BI and Paginated (SSRS) reports on our Power BI Report Servers. We have tested Office Online Server (OOS) on one of our development servers and it works exactly as we need. The end users are excited to add this capability to make PBIRS a "one stop shop" for internal reports. We have multiple business domains, and we plan to install one OOS instance per domain. However, one of the production servers we intend to use is running Windows Server 2019, and Microsoft does not appear to support OOS instances on a 2019 box. If this is the case, how can we provide Excel workbook support on PBIRS? A short term solution would be to stand up a separate 2016 server (which we'd rather not do), but even if we did that what happens to Excel support when 2016 reaches end-of-life?
mjbernier
4 years ago Place Report Server
1.3KViews
0likes
2Comments
OOS fails after May 2021 update
We are late testing the May 2021 Report Server update, and encountered a problem with Office Online Server (OOS) now failing when trying to view Excel workbooks. We initially received the error message "We are unable to complete your request. Please wait a few minutes and try again." Thinking we needed to restart the OOS service following the Report Server update, we did so. Now when we try to open a workbook we get a gray screen with the message "Connection has been reset". We then tried restarting both the Report Server service and OOS, but the connection error persists. Is there something else we're missing? The report server is running on a Windows Server 2012 R2 machine, and is rendering both Power BI reports and Paginated reports without issue.
mjbernier
5 years ago Place Report Server
713Views
0likes
1Comment
Excel workbook refresh with SSAS connection on Report Server
Hi, I have a bunch of Excel workbooks connected to an on-prem tabular model (SSAS). I publish these reports by uploading them to an on-prem Power BI Report Server. However, while the refresh data upon opening workbook works fine locally and also worked fine in a former Sharepoint site, the workbooks do not refresh upon opening when uploaded to Power BI Report Server. Is this feature supported in such a setup? Or is there another way to refresh data and make sure the users see updated data? Thanks in advance!
Solved
Anonymous
5 years ago Place Report Server
1.1KViews
0likes
1Comment