OData Feeds (live Power BI and Excel integrations)

OData Feeds represent a major step forward in live data sharing over the internet without the need to develop APIs.  

All ESdat users have access to an OData Feed.  An Enterprise OData Feed is also available for providing data to a broader audience, including non-ESdat users (additional fee applies).

The OData Feed means users can securely connect to live ESdat data over the web and view their data in external applications, in particular Power BI, Excel and Power Query.   Users can then create their own Power BI dashboards, or their own Excel graphs or calculations that can auto-update with the latest data in ESdat.

Data Feeds are available for all common data types in ESdat, including:

• Projects,
• Sites,
• Locations, 
• Chemistry Results, 
• Groundwater Levels, 
• Boreholes,
• Geology

If you have ESdat Server and can customise your database views you can add your own custom database views as OData feeds under Setup - External Data Feeds.

To create your OData Feed you first need to set up a specific Application Password for use through the OData Application.  This will be different to the password you use to log into ESdat.   

To use this in Power BI:

Select  Get Data - Other – OData Feed

To use this in Excel:

Select Get Data - From Other Sources - From OData Feed    (may vary depending on Excel version)

When prompted for your URL enter the relevant URL below if you're using ESdat Online systems:

If you have your own dedicated url such as yourcompany.esdat.net   then you should enter   yourcompany.esdat.net/OData 

You will be prompted for an Authentication.  Select "Basic" and enter your ESdat Username and the Application Password generated earlier.    Power BI and Excel will store these login details for you on the local machine / user profile so you don't need to enter it each time. 

You should now be able to select some ESdat Data Feeds.