OData with MS Excel

The steps below show you how to user Microsoft Excel

Data > Get Data > From Other Sources > From ODataFeed

A pop-up window then appears to input the discovery URL:

A Navigator window then appears, listing all the resources (data tables in the warehouse) on the left. Here you can select the table(s) you require > Load and begin your analysis as required.