cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
m8909110
Regular Visitor

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-err...,  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!

 

 

1 REPLY 1
m8909110
Regular Visitor

Re: PowerBI Report + OOS: Excel with AS works, but Excel with PowerPivot fail

To resolve Performance counter issue, try to update SQL patch, refer to here:

https://docs.microsoft.com/en-us/sharepoint/support/experts-admin/cannot-locate-a-server-to-load-wor...

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.