PowerPivot for SharePoint 2016 error “We cannot locate a server to load the workbook Data Model”

Scenario: You install PowerPivot for SharePoint 2016 (or PowerBI Report Server) and use SQL 2017 as the data model server (Analysis Services in SharePoint mode). You have configured Office Online Server and all of the other dependencies to properly render workbooks and slice data, but you still receive the following error when you attempt the…

0