Pivot Table Operation failed. We cannot locate a server to load the workbook Data Model.
Tested Environment: -
Power BI Report Server - SQL Server Enterprise with Software Assurance
SQL Server 2017
Power BI Report Server 2017 Microsoft 1.1.6514.9163 (October 2017)
We looked at the ULS logs of the OOS at “C:\ProgramData\Microsoft\OfficeWebApps\Data\Logs\ULS” path and found that “Check Administrator Access (Server Name\POWERPIVOT): Fail” call failed. This indicates the network service account doesn’t have admin privileges on PowerPivot instance.
In my case, I was able to resolve the issue by providing administrator permission to NT AUTHORITY\NETWORK SERVICE account on my SSAS PowerPivot instance.
To do this: -
Connect to Power Pivot instance of SSAS from SSMS.
Right click on it and then click on properties.
Select the security tab and then click on Add.
Provide the NT AUTHORITY\NETWORK SERVICE account and then ok.
Verify that, Network account is added successfully as shown below.
Varun Kulkarni – Support Engineer, SQL Server BI Developer team, Microsoft
Sarath Babu Chidipothu – Support Escalation Engineer, SQL Server BI Developer team, Microsoft