Using the ClearPoint API to integrate with PowerBI

The ClearPoint API allows ClearPoint to integrate with other applications. If you want to learn about our API in general, check out Getting started with the ClearPoint API . In this article, we cover using the API to get ClearPoint measure data into PowerBI.

Feature available for Enterprise Plan customers

Selecting the measure in ClearPoint

To start, you will need to get the ID of the measure you want to transfer data from into PowerBI. In ClearPoint, you can find the Measure ID by navigating to the measure detail page and looking at the URL bar of your browser. Copy the numbers after ‘objectId’ and save them somewhere to use later.

You can also click the pencil icon and then Edit Layout to drag and drop the Measure ID field onto the detail page. Once those changes are saved, you will see the Measure ID in the field and can copy it from there.

Next, navigate to System Settings and then Admin Options. Click on the API Keys tile. Follow the instructions in the Getting and using ClearPoint API keys help article to obtain the Access Key and Secret Key. Save these two keys somewhere as well to be used along with the Measure ID in PowerBI.

Integrating with PowerBI

In PowerBI, click on Get Data and then select Web from the dropdown menu.

Click on the bubble next to Advanced. In the URL parts field, type the URL we have provided below, replacing {measureId} with the numbers that correspond to the measure ID you copied from ClearPoint.

https://app.clearpointstrategy.com/api/v1/measures/{measureId}/measureData

Under HTTP request header parameters, type accessKey and secretKey. In the field next to each key, paste in the corresponding keys from ClearPoint. Finally, click OK.

Note: In Power BI the information is imported as text. In order to plot the measure data as numbers, you will have to convert the column “value” to a number format.

To get more information about your measure or other elements into Power BI, you can setup similar connections but making calls to different URL endpoints. See our API documentation for a full list of possibilities.