Not all data refresh are supported in Excel for the web, it's depending on how your environment is configured. Please refer to this support article and check if you can refresh data in Excel desktop app:
refreshing-data-in-a-workbook-in-a-browser-window-89560193-0c11-420b-b7d8-744766ccdc94