SumTotal.ODataFeed

Updated on

SumTotal.ODataFeed is a Power Query M function that connects to SumTotal’s external facing OData API service to pull data from a data warehousing database. It enables you to filter, expand, slice and create custom visuals and reports based on data returned from the OData feed.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

SumTotal.ODataFeed( url as text ) as table

Description

SumTotal’s Custom connector connects to SumTotal’s external facing OData API service to pull data from data warehousing database . Filter expand, slice and create customer visuals and reports based on data returned from the OData feed

Examples

Returns a table with specified entity data

// Output:  Source{[Name='{OData Entity chosen}']}[Data]
SumTotal.ODataFeed( 'https://host.sumtotalystems.com/?rowVersionId=0' )

Contribute » | Contributors: Rick de Groot