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

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

trishmalloy — Fri, 15 Dec 2017 20:52:09 GMT

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.

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

riccardomuti — Tue, 19 Dec 2017 01:22:22 GMT

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.

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

Anonymous — Wed, 24 Oct 2018 18:42:17 GMT

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.

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

trishmalloy — Wed, 24 Oct 2018 19:06:18 GMT

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?

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

Anonymous — Thu, 25 Oct 2018 08:49:51 GMT

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.