Excel incorporates Power Query (also called Get & Transform) technology to provide greater capability when importing, refreshing, and authenticating data sources, managing Power Query data sources, and shaping the data into a table that fits your requirements.
You can refresh data sources on Excel for the web:
To refresh all data sources in a workbook, select Data > Refresh All Connections.
To refresh all queries in the workbook, select Data > Queries, and then in the Queries pane, next to n queries, select Refresh .
To refresh a specific query, select Data > Queries, and then in the Queries pane, next to the query name, select Refresh .
To refresh a specific query group, select Data > Queries, and then in the Queries pane, next to the group name, select Refresh .
To refresh a specific PivotTable connected to a query, select a cell in the PivotTable, and then select Data > Refresh Selected Connection.
For more information about supported data sources in Excel for the Web, see Power Query data sources in Excel versions.
You can view your queries and related details in the Queries task pane. You can also perform various grouping tasks to better organize your queries. For more information, see Manage queries.