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
  2. Configuring Power Query in Excel

1. Allowing Access to the API

In order to use Power Query, you will first need to enable API access:

Note:

  • You can enable access for any user as an exception. However, if the user you enable has limited access to data within the system, this will not be the case with the API. Therefore you should only enable access for certain users.

2. Configuring Power Query in Excel

  1. Open Excel and select Data >> Get Data >> From Other Sources >> From OData Feed
  1. Enter the OData Feed address - "https://w3.cezanneondemand.com/cezanneondemand/v7/dataservice.svc/" and click OK:
  1. Select 'Basic' from the side panel.
  2. Enter your Cezanne Username and Password.
  3. Select the long url 'https://w3.cezanneondemand.com/cezanneondemand/v7/dataservice.svc'
  4. Click Connect.
  1. When the OData feed loads, select one of the items from the Navigator.
  2. Select Transform Data:
  1. Click Continue to change the data privacy:
  1. Select Public and click Save: