Power BI Connector for OData

Build 20.0.7654

Stored Procedures

Stored procedures are available to complement the data available from the Data Model. It may be necessary to update data available from a view using a stored procedure because the data does not provide for direct, table-like, two-way updates. In these situations, the retrieval of the data is done using the appropriate view or table, while the update is done by calling a stored procedure. Stored procedures take a list of parameters and return back a dataset that contains the collection of tuples that constitute the response.

CData Power BI Connector for OData Stored Procedures

Name Description
CreateAssociation Creates an association between two entities based on a navigation property.
GetOAuthAccessToken Gets the auth token used to authenticate to the service.
GetOAuthAuthorizationUrl Gets an authorization URL from the data source. The authorization URL can be used to generate a verifier required to obtain the OAuth token.
GetSAPCSRFToken Returns a CSRF token and cookie for authentication to SAP.
ListAssociations Lists associations for a given table and navigation property.
ListNavigationProperties Lists navigation properties for a given table and the tables they are associated with. Navigation properties are used by the Association stored procedures.
RefreshOAuthAccessToken Obtains an updated OAuthAccessToken if passed a token to refresh.
RemoveAssociation Removes an association between two entities based on a navigation property.
Search Searches OData using the given URL.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654