none
Excel Workbook with Excel Data Model stored on SharePoint - daily refresh RRS feed

  • Question

  • I'm not sure if this is exactly the right forum but I'm hoping that someone here can either answer or point me in the right direction.

    I have an Excel Workbook with an Excel Data Model.

    The Excel Data Model uses SQL to contact our data warehouse and pull through data into tables.

    We are storing the Workbook on a SharePoint site and viewing it using Excel Services.

    The data in our data warehouse is updated daily and so I would like to refresh the workbook daily and remove the option to refresh the data in the browser.

    Is this possible with a workbook that has an Excel Data Model (I've seen lots of posts that relate to workbooks with connections to tabular models).

    Thanks
    Paul

    Wednesday, July 9, 2014 7:38 AM

Answers

  • Have you hosted your power pivot on SharePoint on premise or SharePoint Online.

    Anyway you can schedule a automatic refresh in both environments.

    For SharePoint OnPremise: http://msdn.microsoft.com/en-us/library/gg413467(v=sql.110).aspx 

    For Share Point Online: http://office.microsoft.com/en-in/office365-sharepoint-online-enterprise-help/schedule-data-refresh-for-workbooks-in-power-bi-for-office-365-HA104180761.aspx

    Thanks,

    Sagar K


    Wednesday, July 9, 2014 8:20 AM

All replies