none
Odata automatic refresh in sharepoint

    General discussion

  • Hi. I have imported a OData feed to POWERBI and have few slicers and charts. How to refresh the OData feed with a particular time of interval in share point site since my data are dynamic. Thanks in advance

    Thursday, March 13, 2014 4:03 AM

All replies

  • basically you need to follow these steps:

    1) upload the Excel workbook with the Power Pivot model to SharePoint Online
    2) go to your Power BI site
    3) Enable the workbook for Power BI
    4) a new menu item appears for "Schedule data refresh"
    5) the rest should be self explaining

    there are still some issues with authentication

    in case you use public data feeds i just published a blog post on how to get scheduled data refresh working for them:
    http://blog.gbrueckl.at/2014/03/scheduled-data-refresh-odata-sources-power-bi/

    hth,
    gerhard


    Gerhard Brueckl
    blogging @ http://blog.gbrueckl.at
    working @ http://www.pmOne.com

    Thursday, March 13, 2014 9:58 AM