Forum Discussion

andrewvinci's avatar
andrewvinci
Copper Contributor
Dec 15, 2022

Excel Online Refreshing SQL Data Source

We have some excel files that are typically used in sharepoint/excel online, and have connections to SQL databases, and also some web API endpoints.

 

Is there any way excel online can refresh these data connections?

2 Replies

  • peiyezhu's avatar
    peiyezhu
    Bronze Contributor
    excel online web Excel? what you mean refreshing data source? as for as I know, connect data source need ODBC driver support,so,online web Excel impossible。
    • andrewvinci's avatar
      andrewvinci
      Copper Contributor
      Excel Online/Web could use the same infrastructure as PowerBI (gateway etc) to refresh data sources, so it's definitely possible.

Resources