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

Excel Power Pivot Report in Power BI Report Server

Hi all,

 

I have a report that was created via Power Pivot in Excel. It have connections to SQL databases(not Analysis Services) via queries.

 

I have imported this report to Power BI Report Server but neither I can create a scheduled refresh nor applying a filter.

 

Error message: "We cannot locate a server to load the workbook Data Model."

 

How can I handle this? 

 

Thanks in advance.

 

 

6 REPLIES 6
Jon-Heide Established Member
Established Member

Re: Excel Power Pivot Report in Power BI Report Server

Currently scheduling a refresh of Excel files with PowerPivot models is not yet supported. If you are having problems viewing the excel document, ensure you have Office Online server configured correctly with the report server. 

 

https://docs.microsoft.com/en-us/power-bi/report-server/excel-oos

 

husss Regular Visitor
Regular Visitor

Re: Excel Power Pivot Report in Power BI Report Server

Hello,

 

Status did not change, I can still neither refresh the report nor applying the filter. I configured the Office Online Server as it says but it did not work.

 

Best regards.

husss Regular Visitor
Regular Visitor

Re: Excel Power Pivot Report in Power BI Report Server

Hello again,

 

I have learned that Analysis Services with Power Pivot mode is needed to be installed. I think this will be the solution of our problem.

 

 

VictorM
Advisor

Re: Excel Power Pivot Report in Power BI Report Server

Hello  @husss,

 

You got it Smiley Happy A SSAS instance in PowerPivot mode is needed. Once you have it installed, just configure the OOS with the following PS command:

 

New-OfficeWebAppsExcelBIServer -ServerID "ServerInstanceName"

I have configured it this way and got it working seamlessly. Hope this helps.

 

Regards,

Víctor M.

husss Regular Visitor
Regular Visitor

Re: Excel Power Pivot Report in Power BI Report Server

Hello @VictorM,

 

We established an Analysis Services with PowerPivot mode, but problem is still continuing. We made all the instructions on Microsoft's document page, but it still does not work. Probably we are not able to tell the PBIRS that it needs to use this Analysis Services with PowerPivot mode.

 

did we miss something I could not understand :/ 

 

Best regards.

m8909110 Frequent Visitor
Frequent Visitor

Re: Excel Power Pivot Report in Power BI Report Server

Hi Huss,

 

Recently, we tested Power BI Report Server + Office Onine Server. Excel connected to SSAS or Excel with Power Pivot all work fine. We encountered your error message as well. Check SQL server version, if SQL2017, upgrated to CU3 or higher. The error was cause by missing peroformace counter( You can find error message in ULS log).

 

Best Regard!

 

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 157 members 2,179 guests
Please welcome our newest community members: