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.Current state of Office Online Server - July 2018
I've been experimenting a bit today with installing OOS on our dev PBIRS installation, and it's been a bit of a kludgy experience. Some of it may have to do the standard build of our servers, but it got me wondering why the documentation still states: https://docs.microsoft.com/en-us/power-bi/report-server/excel-oos Limitations and considerations -The ability to view Excel workbooks within Power BI Report Server is currently in preview Is there any specific reason it's still considered "preview" that we should be aware of? Most of the OOS posts I've read have been from last year. I found that I needed to track down our Server 2012 R2 installation media and modify the documented steps to let the "Add-WindowsFeature" steps complete. Once I worked past that and attempted to retrieve the dev key from MSDN as suggested, I found that even the dev key is restricted to Visual Studio Enterprise w/ MSDN, which leaves us in the lurch since we've only had need for Visual Studio Professional w/ MSDN. We're essentially stuck until I work out getting access to the OOS install from our corporate team, so I thought I'd ask here. What is needed to bring it out of preview? Is there any initiative in place to streamline some of this configuration?
OOS and PBIRS Integration WOPI proof key validation failed
Dear Community, I'm trying to get OOS and PBIRS integrated successfully however after publishing an Excel file to PBIRS I see that the file is deployed but I can neither view it online (You do not have permissions to open this file in the browser) nor successfully download it. I'm being offered the download but neither Open / Save will complete. Here's the output from RSOffice.log 2019-12-04 08:48:29.3956|INFO|33|Received request GET /files/202dbfc5-8a46-4832-91d9-3abf68c15bf1| RequestID = s_981f4773-d3df-4faa-ab8c-edfd2f665995 2019-12-04 08:48:29.4268|INFO|33|Loading office proof keys from https://oos.tld.url/hosting/discovery.| RequestID = s_981f4773-d3df-4faa-ab8c-edfd2f665995 2019-12-04 08:48:29.4737|INFO|33|Retrying proof key validation with updated office proof keys| RequestID = s_981f4773-d3df-4faa-ab8c-edfd2f665995 2019-12-04 08:48:29.4737|ERROR|33|WOPI proof key validation failed.| RequestID = s_981f4773-d3df-4faa-ab8c-edfd2f665995 Here's what RSPortal.log has to offer: 2019-12-04 08:48:27.4424|INFO|136|Received request GET /api/v2.0/CatalogItems%28Path%3D%27/tabular-test%27%29| RequestID = s_13f45275-10c3-4d7f-83e3-9c2568b9cff7 2019-12-04 08:48:27.6611|INFO|116|Sending response. Response code Domain\Dino 200, Elapsed time 0:00:00,2224888| RequestID = s_13f45275-10c3-4d7f-83e3-9c2568b9cff7 2019-12-04 08:48:28.9581|INFO|136|Received request GET /api/v2.0/CatalogItems%28Path%3D%27/tabular-test/tabular-test.xlsx%27%29| RequestID = s_c7ed7acc-20e3-45ff-9b48-70d19626068f 2019-12-04 08:48:28.9581|INFO|60|Sending response. Response code Domain\Dino 200, Elapsed time 0:00:00,0060778| RequestID = s_c7ed7acc-20e3-45ff-9b48-70d19626068f 2019-12-04 08:48:28.9893|INFO|136|Received request GET /api/v2.0/CatalogItems%28Path%3D%27/tabular-test/tabular-test.xlsx%27%29| RequestID = s_3472b110-d11f-4dd6-bcc2-f8a6df7827f5 2019-12-04 08:48:29.0049|INFO|76|Sending response. Response code Domain\Dino 200, Elapsed time 0:00:00,0058407| RequestID = s_3472b110-d11f-4dd6-bcc2-f8a6df7827f5 2019-12-04 08:48:29.0205|INFO|136|Received request GET /api/v2.0/CatalogItems%28202dbfc5-8a46-4832-91d9-3abf68c15bf1%29/Model.AccessToken| RequestID = s_783ef77c-8849-479c-b2b9-4e6aaef91069 2019-12-04 08:48:29.0362|INFO|116|Sending response. Response code Domain\Dino 200, Elapsed time 0:00:00,0057521| RequestID = s_783ef77c-8849-479c-b2b9-4e6aaef91069 2019-12-04 10:04:38.3415|INFO|74|Received request GET /api/v2.0/CatalogItems%28Path%3D%27/tabular-test%27%29| RequestID = s_a0a095d2-c086-4864-8ac1-6e7de97f18b7 2019-12-04 10:04:38.4665|INFO|115|Sending response. Response code Domain\Dino 200, Elapsed time 0:00:00,1290803| RequestID = s_a0a095d2-c086-4864-8ac1-6e7de97f18b7 2019-12-04 10:04:39.4041|INFO|74|Received request GET /api/v2.0/CatalogItems%28Path%3D%27/tabular-test/tabular-test.xlsx%27%29| RequestID = s_f8529cab-706a-4e40-a5c4-4d53350a1f3d 2019-12-04 10:04:39.4197|INFO|76|Sending response. Response code Domain\Dino 200, Elapsed time 0:00:00,0109516| RequestID = s_f8529cab-706a-4e40-a5c4-4d53350a1f3d 2019-12-04 10:04:39.4509|INFO|74|Received request GET /api/v2.0/CatalogItems%28Path%3D%27/tabular-test/tabular-test.xlsx%27%29| RequestID = s_24c4bd99-99a2-4f3d-be22-58b02ed789cf 2019-12-04 10:04:39.4665|INFO|76|Sending response. Response code Domain\Dino 200, Elapsed time 0:00:00,010891| RequestID = s_24c4bd99-99a2-4f3d-be22-58b02ed789cf 2019-12-04 10:04:39.4978|INFO|74|Received request GET /api/v2.0/CatalogItems%28202dbfc5-8a46-4832-91d9-3abf68c15bf1%29/Model.AccessToken| RequestID = s_e447755d-d0ba-4e9c-8d5c-130dbf30a830 2019-12-04 10:04:39.4978|INFO|76|Sending response. Response code Domain\Dino 200, Elapsed time 0:00:00,0061392| RequestID = s_e447755d-d0ba-4e9c-8d5c-130dbf30a830 and here is the Output from RSManagement.log 2019-12-04 01:17:00.5926|ERROR|11|Unhandled error in the Web API. Exception: System.Net.Http.HttpRequestException: Error while copying content to a stream. ---> System.IO.IOException ---> System.Net.HttpListenerException: The I/O operation has been aborted because of either a thread exit or an application request at System.Net.HttpResponseStream.EndWrite(IAsyncResult asyncResult) at Microsoft.Owin.Host.HttpListener.RequestProcessing.ExceptionFilterStream.EndWrite(IAsyncResult asyncResult) --- End of inner exception stack trace --- at Microsoft.Owin.Host.HttpListener.RequestProcessing.ExceptionFilterStream.EndWrite(IAsyncResult asyncResult) at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization) --- End of inner exception stack trace --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Owin.HttpMessageHandlerAdapter.<SendResponseContentAsync>d__20.MoveNext()| RequestID = s_aceaa855-ef46-489b-afdf-58cfa44fc888 2019-12-04 01:17:00.5926|INFO|11|Domain\dom_s_dev-sqlsrs010 127.0.0.1: GET /api/v1.0/ManagementState - 0:00:00.087999 Connection dropped| RequestID = s_aceaa855-ef46-489b-afdf-58cfa44fc888 System.Threading.Tasks.TaskCanceledException: A task was canceled. at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Owin.HttpMessageHandlerAdapter.<SendResponseContentAsync>d__20.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Owin.HttpMessageHandlerAdapter.<InvokeCore>d__0.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.BIServer.Management.WebHost.RequestLoggingMiddleWare.<Invoke>d__2.MoveNext() 2019-12-04 02:25:09.5824|ERROR|11|Unhandled error in the Web API. Exception: System.Net.Http.HttpRequestException: Error while copying content to a stream. ---> System.IO.IOException ---> System.Net.HttpListenerException: The I/O operation has been aborted because of either a thread exit or an application request at System.Net.HttpResponseStream.EndWrite(IAsyncResult asyncResult) at Microsoft.Owin.Host.HttpListener.RequestProcessing.ExceptionFilterStream.EndWrite(IAsyncResult asyncResult) --- End of inner exception stack trace --- at Microsoft.Owin.Host.HttpListener.RequestProcessing.ExceptionFilterStream.EndWrite(IAsyncResult asyncResult) at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization) --- End of inner exception stack trace --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Owin.HttpMessageHandlerAdapter.<SendResponseContentAsync>d__20.MoveNext()| RequestID = s_50acbe1e-6d5e-46b7-a369-73500d1047b8 2019-12-04 02:25:09.6136|INFO|11|Domain\dom_s_dev-sqlsrs010 127.0.0.1: GET /api/v1.0/ManagementState - 0:00:00.0940827 Connection dropped| RequestID = s_50acbe1e-6d5e-46b7-a369-73500d1047b8 System.Threading.Tasks.TaskCanceledException: A task was canceled. at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Owin.HttpMessageHandlerAdapter.<SendResponseContentAsync>d__20.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Owin.HttpMessageHandlerAdapter.<InvokeCore>d__0.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.BIServer.Management.WebHost.RequestLoggingMiddleWare.<Invoke>d__2.MoveNext() 2019-12-04 03:03:09.1768|ERROR|11|Unhandled error in the Web API. Exception: System.Net.Http.HttpRequestException: Error while copying content to a stream. ---> System.IO.IOException ---> System.Net.HttpListenerException: The I/O operation has been aborted because of either a thread exit or an application request at System.Net.HttpResponseStream.EndWrite(IAsyncResult asyncResult) at Microsoft.Owin.Host.HttpListener.RequestProcessing.ExceptionFilterStream.EndWrite(IAsyncResult asyncResult) --- End of inner exception stack trace --- at Microsoft.Owin.Host.HttpListener.RequestProcessing.ExceptionFilterStream.EndWrite(IAsyncResult asyncResult) at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization) --- End of inner exception stack trace --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Owin.HttpMessageHandlerAdapter.<SendResponseContentAsync>d__20.MoveNext()| RequestID = s_8b0f5374-ba77-451d-89b1-96391a2563aa 2019-12-04 03:03:09.1768|INFO|11|Domain\dom_s_dev-sqlsrs010 127.0.0.1: GET /api/v1.0/ManagementState - 0:00:00.0410533 Connection dropped| RequestID = s_8b0f5374-ba77-451d-89b1-96391a2563aa System.Threading.Tasks.TaskCanceledException: A task was canceled. at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Owin.HttpMessageHandlerAdapter.<SendResponseContentAsync>d__20.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Owin.HttpMessageHandlerAdapter.<InvokeCore>d__0.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.BIServer.Management.WebHost.RequestLoggingMiddleWare.<Invoke>d__2.MoveNext() 2019-12-04 03:56:32.1653|ERROR|14|Unhandled error in the Web API. Exception: System.Net.Http.HttpRequestException: Error while copying content to a stream. ---> System.IO.IOException ---> System.Net.HttpListenerException: The I/O operation has been aborted because of either a thread exit or an application request at System.Net.HttpResponseStream.EndWrite(IAsyncResult asyncResult) at Microsoft.Owin.Host.HttpListener.RequestProcessing.ExceptionFilterStream.EndWrite(IAsyncResult asyncResult) --- End of inner exception stack trace --- at Microsoft.Owin.Host.HttpListener.RequestProcessing.ExceptionFilterStream.EndWrite(IAsyncResult asyncResult) at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization) --- End of inner exception stack trace --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Owin.HttpMessageHandlerAdapter.<SendResponseContentAsync>d__20.MoveNext()| RequestID = s_50f86365-d65d-45ed-877f-26d2e111a7f7 2019-12-04 03:56:32.1653|INFO|14|Domain\dom_s_dev-sqlsrs010 127.0.0.1: GET /api/v1.0/ManagementState - 0:00:00.0541593 Connection dropped| RequestID = s_50f86365-d65d-45ed-877f-26d2e111a7f7 System.Threading.Tasks.TaskCanceledException: A task was canceled. at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Owin.HttpMessageHandlerAdapter.<SendResponseContentAsync>d__20.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Owin.HttpMessageHandlerAdapter.<InvokeCore>d__0.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.BIServer.Management.WebHost.RequestLoggingMiddleWare.<Invoke>d__2.MoveNext() 2019-12-04 09:25:49.4330|ERROR|4|Unhandled error in the Web API. Exception: System.Net.Http.HttpRequestException: Error while copying content to a stream. ---> System.IO.IOException ---> System.Net.HttpListenerException: The I/O operation has been aborted because of either a thread exit or an application request at System.Net.HttpResponseStream.EndWrite(IAsyncResult asyncResult) at Microsoft.Owin.Host.HttpListener.RequestProcessing.ExceptionFilterStream.EndWrite(IAsyncResult asyncResult) --- End of inner exception stack trace --- at Microsoft.Owin.Host.HttpListener.RequestProcessing.ExceptionFilterStream.EndWrite(IAsyncResult asyncResult) at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization) --- End of inner exception stack trace --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Owin.HttpMessageHandlerAdapter.<SendResponseContentAsync>d__20.MoveNext()| RequestID = s_7524741a-cb00-4c48-afe3-63b06b10f0b3 Both OOS and PBIRS reside on the same server, there is a valid certificate with SANs for both https://oos.tld.url and https://powerbi.tld.url and the Server name. I am able to open the discovery url without any issues. Any help would be really appreciated.
Refresh Excel workbook with PowerPivot
Hi, A while ago the Roadmap for PBIRS had a feature with the ability to refresh Excel with PowerPivot. It's not there anymore, so i guess that feature isn't coming anytime soon. chrisfin had a blogpost showing how we could use a thrid party tool called PowerUpdate to refresh the Excel workbooks. We prefer not using 3. party tools. He also mentioned that anyone could do this with the REST API. So my question is: Is the ability to refresh Excel workbooks with PowerPivot coming natively to PBIRS (anytime soon)? ...Or does anyone have a script which refreshes Excel workbooks on PBIRS that they would like to share with the community. Regards Taico
PowerBI Report + OOS: Excel with AS works, but Excel with PowerPivot fail
Dear Masters, We setup PowerBI Report Server(15.0.1102.235) and Office Online Server(OOS) is one server, also intsall 2 SSAS instances(SQL2012), one for tabluar model, another for PowerPivot mode in same server. We uploaded 2 excel files to PBIRS, ones' source cnnected to SSAS tabular model, it could work well, like add/move dimension. But another file with PowerPivot, it can be open, when we add dimension into Pivot table, error message prompted: We cannot locate a server to load the workbook Data Model. It look seems OOS cannot connect to SSAS PowerPivot mode, we check log file, here is error message: Checking Server Configuration (twtpewgdwdb02d\POWERPIVOT) ... 05/09/2019 11:06:46.53 w3wp.exe (0x20DC) 0x4A88 Excel Online Data Model sql01 Medium --> Check Administrator Access (twtpewgdwdb02d\POWERPIVOT): Pass. Check Server Version (twtpewgdwdb02d\POWERPIVOT): Pass (14.0.1.278 >= 11.0.2800.0). Check Deployment Mode (twtpewgdwdb02d\POWERPIVOT): Pass. Check Server Configuration (twtpewgdwdb02d\POWERPIVOT): Pass. SSPM: Initialization failed on server twtpewgdwdb02d\POWERPIVOT: Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: The '\MSOLAP$POWERPIVOT:Memory\Memory Limit High KB' performance counter could not be found. Refer https://docs.microsoft.com/en-us/sharepoint/support/experts-admin/powerpivot-performance-counter-errors, there is no "Disable Performance Counters" in system registry, so...we add manually, but still not fix the error. Finally, follow isstruction, we try to re-create the performance counter, run below command: unlodctr msolap$pwerpivot Error message prompt: Unable to open driver SYSTEM\CurrentControlSet\Services\msolap. Is anything wrong or any suggestion? Many thank!Excel online on OOS server, excel renders but is unable to change slicers.
Im am getting error, "The workbook attempts to utilize ODC File to connect to a data source. You are not licensed to use this feature" The excel file i am rendering in pbi report server with oos server installed on the same machine runs normally with all slicers and filters in excel desktop. however when it has been uploaded to the pbi report server the mentioned error is displayed. Other Excel files give me this error "External Data Refresh Failed, An error occorred during an attempt to establish a connection......" All these excel files are connected to an ssas cubes. I also have a few pbi reports rendering inside the same pbi report server and they do not have any issues regarding filters and slicers.
Error .. Installing OOS - Office Online Server after PBIRS (Power BI Report Server) (on premise)
Hi I am following the steps as per this link https://powerbi.microsoft.com/en-us/documentation/reportserver-excel-oos/#prepare-server-to-run-office-online-server Getting error at the stage: "Create the Office Online Server farm (HTTPS)" or "Create the Office Online Server farm (HTTP)" New-OfficeWebAppsFarm : The operation failed. The server did not meet the following prerequisites: - Microsoft Office is installed on this machine. Please remove it. At line:1 char:1 + New-OfficeWebAppsFarm -InternalURL "http://dev-myserver01/OOS" -AllowHttp + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotInstalled: (:) [New-OfficeWebAppsFarm], InvalidOperationException + FullyQualifiedErrorId : PrerequisiteFailure,Microsoft.Office.Web.Apps.Administration.NewFarmCommand FYI, I dont have Microsoft Office on this server ... Please advice Thanks
