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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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!