Power BI Report Server v14.0.600.437 - All reports with a PowerPivot Data Model not working

[trishmalloy]

We are wanting to move all of our SSRS, non-SSAS Excel, Power BI and PowerPivot reports into PBIRS, all reports except the ones using a PowerPivot Data Model work fine.  When interacting with the report, seen below, the error comes up.

[riccardomuti · Accepted solution]

To support Excel workbooks with Power Pivot data models, Office Online Server requires an instance of Analysis Services in Power Pivot mode. See https://docs.microsoft.com/en-us/power-bi/report-server/excel-oos under "Configure a Power Pivot instance for data models". See also https://whitepages.unlimitedviz.com/2016/03/enable-powerpivot-support-in-office-online-server-2016/ for more info about installing Analysis Services in Power Pivot mode.

[Anonymous]

Hello,

I am also having this problem now. I have a power pivot report that have connections to SQL database via queries, and imported it to PBIRS. But I can not refresh it and apply filter. My report is also not Analysis Services. 

I think the document you provide is not our solution unfortunately 😞 

Can you help?

Thanks in advance.

[trishmalloy]

You looked at the links Ricardo posted?  It looks like I posted this over a year ago which means I honestly don't remember what fixed this, I'm guessing one of the two articles Ricardo posted helped to solve the issue.  You have an OOS server set up?

[Anonymous]

Hello @trishmalloy,

the first document is about installing OOS and I have done it, but other document is again about Analysis Services Configuration. My report is not connected with analysis Services, so I do not think it will work.