Can I refresh a workbook with Power Query from online sources on SharePoint Online RRS feed

  • Question

  • This question seems to have been asked recently but I want to be sure:

    I have an Excel 2010 workbook with no data model. It contains a report based on CRM Online data that is accessed via the odata service using Power Query. I want to store it on SharePoint Online. When I choose Refresh All Connections on SharePoint Online I get the message:

    We were unable to refresh one or more data connections in this workbook. The following connections failed to refresh: Power Query [queryname].

    I am thinking that this refresh is a feature that is not available yet. Can someone please confirm?


    Tuesday, June 23, 2015 4:12 PM


All replies