Retrieve data for a data view

After you create and configure a data view, you can programmatically retrieve the data set that it resolves to using the CONNECT data services REST API. With a data-driven application (like Microsoft Power BI), you can leverage the data view for data science enablement.

Data retrieval options

To retrieve a data view, you can either use the CONNECT data services Power BI Connector, or you can interact directly with the CONNECT data services REST API using an example GitHub project as a starting point.

Option A: Microsoft Power BI

You can retrieve a data view using Microsoft Power BI. Retrieving a data view in Microsoft Power BI requires installation of CONNECT data services Power BI Connector. The banner at the top of the Create and configure a data view page contains a link to the Connector.

1. Install the CONNECT data services Microsoft Power BI Connector.

   Install the CONNECT data services Power BI Connector. The banner at the top of the page contains a link to the Connector. If you dismiss the banner, you can still download the connector by selecting More options > Power BI Connector.

   For more information on installing the CONNECT data services Power BI Connector, see Power BI Connector setup.

2. Use Microsoft Power BI to retrieve your data view.

   Use Microsoft Power BI to retrieve your data views. For more information, see Retrieve data views with Power BI Connector.

Option B: Interact with the REST API

Alternative to using Microsoft Power BI, you can interact with the CONNECT data services REST API directly by using a sample project provided by AVEVA. Sample projects for the following technologies are available on GitHub:

• Grafana

• Jupyter

• Python

• R

• .NET

• Java

Complete the following steps to retrieve a data view using the REST API.

3. Create a client-credentials client.

   To retrieve a data view from CONNECT data services, you must authenticate with a valid Client Id and Client secret. You can obtain an Id and secret by creating a set of client-credentials. When you create the client-credentials, accept the default expiry of 3600 seconds. When you receive the client secret, keep it secure, as there is no way to see the secret again. If you lose it, you need to create a new set of client-credentials.

   For more information on creating client-credential clients, see Add a client-credentials client.

4. Configure your sample project and retrieve your data view.

   Use one of the starter projects listed above. Pass your project client-credentials to authenticate and provide it with the URI for your data view. For more information on this process, see the link above.

Tip: Use the API Console to retrieve your data view

While creating or editing a data view, use View in API Console to open the view in the API console. The API console includes the URI and query values for accessing your data view in its current configuration.

View in API Console button