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 tableDescription
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' )2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy