Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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 Serv...
Power Pivot
Report Server
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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's avatar
VictorM
Advocate I
7 years ago

Hello  Anonymous,

 

You got it :) 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.