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. Check Microsoft Office Installation Type
Before downloading Power Query you need to check if your Microsoft Office installation is 32-bit or 64-bit:
- Open Microsoft Excel and
- Navigate to: File >> Account >> About Excel:
![2. Check Microsoft Office Installation Type](https://media.screensteps.com/image_assets/assets/006/084/382/original/2bb7aeea-e9da-4cbe-be87-731fab3870c5.png)
3. Installing Power Query
- Download the Power Query Add-In from the Microsoft website. (Make sure to choose the file which matches your Office Installation from the above step).
![3. Installing Power Query](https://media.screensteps.com/image_assets/assets/006/084/383/original/8bc0c4f7-f3bb-41ca-834a-a7458c46d82e.png)
- Once downloaded, run the MSI installer and follow the setup steps:
![](https://media.screensteps.com/image_assets/assets/006/084/385/original/dcd92899-a88f-4eda-bfc0-b8ed82729d6a.png)
- When the Install has completed, select Finish.
![](https://media.screensteps.com/image_assets/assets/006/084/387/original/53fa9aee-be71-46dc-b601-35109c64fb8a.png)
4. Configuring Power Query in Excel
- Open Excel and select Blank Workbook:
![4. Configuring Power Query in Excel](https://media.screensteps.com/image_assets/assets/006/084/389/original/51d29e55-21d1-495b-aaaa-3af908be575e.png)
- Select Power Query tab
![](https://media.screensteps.com/image_assets/assets/006/084/391/original/7fa095d9-676b-48f3-9b3c-8cacdb3a8efd.png)
- Select From Other Sources >> From OData Feed:
![](https://media.screensteps.com/image_assets/assets/006/084/393/original/8be851c9-ca9a-4d88-9aa9-03d1f2d63613.png)
- Enter the OData Feed address - "https://w3.cezanneondemand.com/cezanneondemand/v2/dataservice.svc/" and click OK:
![](https://media.screensteps.com/image_assets/assets/006/084/395/original/2b7614ca-875f-4a07-9193-616de3bbca5c.png)
- Select 'Basic' from the side panel.
- Enter your Cezanne Username and Password.
- Click Save.
![](https://media.screensteps.com/image_assets/assets/006/084/397/original/2050c927-8d6e-4fbd-9406-486e5ebd1d2d.png)
- When the OData feed loads, select one of the items from the Navigator:
![](https://media.screensteps.com/image_assets/assets/006/084/399/original/48f3858f-7b74-4d9d-9ce3-e14f69c36108.png)
- Click Continue to change the data privacy:
![](https://media.screensteps.com/image_assets/assets/006/084/401/original/da4ade87-0e85-4097-bd10-7730a83a3329.png)
- The query you have selected will now show data from the Cezanne system:
![](https://media.screensteps.com/image_assets/assets/006/084/405/original/7cbd6924-fdf1-4e6c-880f-66469bb27260.png)