WALDO

Applicable plans:

The free plan	The complete plan	On-demand plan
X

To connect your Excel or your PowerBI to Waldo database, you must have Waldo administrative privileges.

You can refer to this documentation: https://customer.hellowaldo.app/a/solutions/articles/8000101561?portalId=8000023605

1 - Option1: Connect with Power BI.

1. Start Power BI Desktop and click on "Get Data".
   
    
2. Enter "OData" and select "OData Feed"
   
   
3. Click "Connect".
   
   
4. Select "Basic" and enter the following URL: https://odata.hellowaldo.app
5. Select "Organizational account" and click "Sign In"
    
6. In the authentication window, select or enter your account. When you are authenticated, click on "Connect".
   
   
7. Select the data you need and click on "Load" to add the data directly to your report or click "Transform" to modify the data.
   

2 - Option 2: Connect with Excel.

1. Start Excel.
2. If needed, activate the Power Pivot for Excel add-in as described here: https://support.microsoft.com/en-us/office/start-the-power-pivot-add-in-for-excel-a891a66d-36e3-43fc-81e8-fc4798f39ea8
   
   
3. Click on data then get data and select From OData Feed.
   
   
   
   
4. Select "Basic", enter the following URL: https://odata.hellowaldo.app, and click ok.
   
5. Select the data you need and click on "Load" to add the data directly to your Excel sheet or click "Transform" to modify the data.
   
   

3 - Tables

3.1 - Ressources

The following tables contain all your resources and configuration specified in your Waldo Admin Portal.

3.2 - Reservations

3.3 - Links

These tables are technical tables to link entities

3.4 - External data

This table presents data that are not stored in your data center. The OData API is using the token to call Microsoft Graph on behalf of the user and get the user's data.