OdataLink's help includes an exhaustive set of How To Guides.
Alternatively, check the following Troubleshooting Guides.
Troubleshooting Guides for Excel
How to reset security permissions linked to the OData Feeds in Excel
How to clear the cache linked to the OData Feeds in Excel
Troubleshooting Guides for OdataLink
Checking OData feed logs
ODataLink OData feed error codes
Troubleshooting Guides for Xero
How to separate Xero Tracking Categories into distinct columns using Power Query