on desktop excel you are able to make a data connection with microsoft query to another database. I cannot find this option in onedrive. when I copied an existing spreadsheet to onedrive and tried to refresh the data the error says the external data refresh failed.