Setting Up Power Query
This article shows how to set up Power Query to access your Cezanne data from within Microsoft Excel using the API. It contains the following sections:
1. Allowing Access to the API
In order to use Power Query, you will first need to enable API access:
2. Configuring Power Query in Excel
- Open Excel and select Data >> Get Data >> From Other Sources >> From OData Feed

- Enter the OData Feed address - "https://w3.cezanneondemand.com/cezanneondemand/v7/dataservice.svc/" and click OK:

- Select 'Basic' from the side panel.
- Enter your Cezanne Username and Password.
- Select the long url 'https://w3.cezanneondemand.com/cezanneondemand/v7/dataservice.svc'
- Click Connect.

- When the OData feed loads, select one of the items from the Navigator.
- Select Transform Data:
- Click Continue to change the data privacy:

- Select Public and click Save: