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 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.

 

 

Power Pivot
Report Server

6 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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.

    • 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.