OData coming from Altru does not contain any metadata and Power Query/Get and Transform requires metadata to run. In order to use OData in Excel, take the following steps:
- Go to the Data tab
- Select From Other Sources
- Select From OData Feed
- Enter your OData link in the box labeled Link or File
- Enter your Altru credentials in the Log on credentials box.
- Click Finish