Access Data & Insights Data using OData

Finding the Odata Endpoint
Analyzing OData through Microsoft Excel
Authenticating in OData
Querying Using OData


Data & Insights datasets, including private datasets, can be accessed through a unique OData endpoint, allowing users to seamlessly connect to their data through a number of different tools.

As of 11/06/2017, Data & Insights's OData endpoints will also support OData v4, following the URL format of https://$domain/api/odata/v4/$dataset_identifier. If you are using the previous version (v2) of OData, endpoints follow this URL structure: https://$domain/OData.svc/$dataset_identifier, we recommend updating to the latest version.

Finding the Odata Endpoint

You can easily locate the OData endpoint for a dataset on a dataset's Primer page.


To access the endpoint through Data & Insights Primer, select the Actions button on the top right of the screen. This will open up a drop-down where you can select Access Data via OData.

This will bring up a pop-up screen which will contain the OData Endpoint for the dataset. You can click on the OData box to choose either the v2 or the v4 endpoint.

Analyzing OData through Microsoft Excel

OData connections are often analyzed through Microsoft Excel. Supported versions of Excel and Power BI for use with Data & Insights OData are:

  1. Power Query Version 2.40.4554.161 or newer - Excel 2010 / Excel 2013
  2. Get & Transform Tool - Excel 2016 version 16.0.6965.2117 or newer
  3. Power BI Desktop - Version 2.42.4611.901 or newer

For more information on using Excel to connect to your OData endpoint, please see the following article

Authenticating in OData

In some cases, it is required to authenticate with your Data & Insights username and password to access an Odata feed. This can be done using the basic authentication option in most software that offers Odata connections.

The main cases for requiring authentication is:

  1. When the dataset or view you are connecting to is Private.
  2. When the dataset or view has been rejected in approvals from view in the catalog. Even though these assets are not private, since they are hidden from the catalog, connecting to these assets will require authentication. (Hint: You can tell if an asset is not approved when it can be viewed on your browser without logging in but the asset is not available in the Public Catalog).

Querying using OData

You can also directly query Data & Insights data using OData as a REST API. Data & Insights datasets follow the OData URI Conventions documented in For more information on OData, see

Note: Not all querying functionality is supported in V4 endpoints, please use V2 endpoints for data filtering. 

Here are some examples of how to apply these conventions to a Data & Insights catalog and dataset:$value$orderby=magnitude$top=2$skip=1005$filter=magnitude%20gt%205$select=magnitude,depth$filter=magnitude%20gt%205&$inlinecount=allpages

Data & Insights Datatypes exposed as OData

This table lists the OData types used to represent Data & Insights data.

Data & Insights Datatype ODataDatatype
Checkbox Edm.Boolean
Date & Time (floating timestamp) Edm.String (the OData V4 protocol has removed the datetime without timezone type)
Date & Time (with timezone) Edm.DateTimeOffset
Document Complext type with Edm.String listing the URL to the document and Edm.String listing the name of the document
Email Edm.String
Location Complex type with Edm.Decimal for latitude/longitude and Edm.String for Address, City, State and Zip
Money Edm.Decimal
Multiple Choice Edm.String
Number Edm.Decimal
Percent Edm.Decimal
Phone Complext type with Edm.String listing the phone number and Edm.String listing the phone type
Photo Edm.String listing the URL to the photo
Text (Formatted) Edm.String with HTML tags
Text (Plain) Edm.String
Website URL Complex type with Edm.String listing the URL and Edm.String listing the description

Four data types are not exposed via OData. These are: Star, Flag, Nested Table and Dataset Link.

Was this article helpful?
3 out of 3 found this helpful
Have more questions? Submit a request



Article is closed for comments.