Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Excel live connect to analysis services

Hi, 

 

We have power bi sales reporting dashboards/reports and are using the cube/model to live connect in excel.  

 

What have others done to share these excel reports with sales people in the business and distributed changes to reports as they are needed? The excel reports are currently stored in Sharepoint.

 

Tina

 

 

General Comment

4 Replies

  • edhans's avatar
    edhans
    Icon for Community Champion rankCommunity Champion
    6 years ago

    why wouldn't you share the Power BI reports? Putting Excel into the mix can cause another point of failure, security issues, etc.

     

    I guess the question is, why are you using Excel to share Power BI cubes?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      We have a consultant that built this before i was hired and my understanding is it was due to performance issues using Power BI (and maybe a bit of the comfort feeling of excel with the business).  They still use the dashboards for higher level analysis and KPI's.

       

       

      • edhans's avatar
        edhans
        Icon for Community Champion rankCommunity Champion
        6 years ago

        Get that company on board with Power BI. I've used Power BI extensively in a small/medium sized business environment and have seen FAR MORE STABILITY in Power BI than anything in Excel using Power Query and Power Pivot. I am constantly moving solutions I've created in Excel to Power BI so it is automated and stable.

         

        THen use  the Analyze in Excel connector for those solutions that must have Excel as an end-point. Like printing data to PDF - something Power Pivot and Excel are better at than Power BI is.