Forum Discussion

amitshah1935's avatar
amitshah1935
Copper Contributor
Jul 16, 2020

Refresh all connections button click on excel online gives an error

We have configured an excel file with a https://services.odata.org/V3/OData/OData.svc/ on excel 2016 desktop. The data is loaded into the sheet from Queries & Connections tab. Refresh works fine here...
excel
Excel for web
  • amitshah1935's avatar
    amitshah1935
    Copper Contributor
    Jul 17, 2020

    SergeiBaklan - Thanks for the reply. 

    > Power Query refresh is not supported by Excel Online

    Ok. I could not find any official documentation stating that but I could get to https://social.msdn.microsoft.com/Forums/sqlserver/en-US/1d4a4875-4492-4efb-b684-d31be99efe0f/data-model-refresh-on-sharepoint-online-with-power-query?forum=sqlkjpowerpivotforexcel#4c154fd2-5dfa-4116-b558-47cb080372dc.

     

    > Perhaps something of this https://docs.microsoft.com/en-us/officeonlineserver/data-authentication-for-excel-online-in-office-online-server  

     

    Thanks for sharing the link. According to this, we need to create a ODC file from the OData service and a custom data provider. Will check more on it.

     

    > Alternatively you may load data to data model through PowerPivot connector and return result back using linked-back tables.

     

    I didn't completely follow on how would it help to refresh the excel data when it changes in the source which is the OData feed in my case.

     

    Thanks.

    • ComputerHabit's avatar
      ComputerHabit
      Brass Contributor
      Sep 17, 2021
      Ever get an answer? I'd like to be able to refresh a spreadsheet I use in Sharepoint and use it in reports elsewhere.
      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Sep 17, 2021

        ComputerHabit Still not available. Now in Excel for web you may see list of queries in right pane, but so far not refresh them.

Resources