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.
In This Article
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.
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.