The ClearPoint API allows clients to integrate their ClearPoint account with other applications and data sources. In this article, we cover using the API to get ClearPoint Measure data into PowerBI.
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, you will find the Measure ID by locating the numbers after ‘objectId’.
For example:
In this example, the Measure ID is 1522940.
Additionally, these steps will help you find the Measure ID by adding the Measure ID field onto a Detail Page.
Select Scorecards & Elements from the Control Panel
Choose Manage Elements
Open Measure
Locate the Measure you are going to be working with, in this example, ‘Revenue’.
Click on the dropdown menu nexto the edit Pencil icon
Select Edit Layout
Locate the Measure ID field on the left panel
Click the Plus icon
Drag and drop the Measure ID field to the desired location
Once you are done with your change click Save
You will find the Measure ID in the Measure Detail Page
How to Add an API Key for Power BI Integration
Click on System Settings from the Control Panel
Select System setup
Click on Integrations under Enterprise Features
Click on the Plus icon
Under API Key Name, enter the name of the new API Key, in this example, ‘PowerBI’.
We recommend using a name that clearly describes the purpose of the API Key for future references.
By default the Expiration will be set to one year in the future but you can customize this date depending on your company policy.
Once you are done with your changes, click Save
Click the newly created API Key
Copy the Access Key and Secret Key
You will need these values to perform the ClearPoint integration with PowerBI.
Integrating with PowerBI
You can download PowerBI here.
In PowerBI click on Get Data
Select Web
A new window will appear From Web
Choose 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:
Following the example above, the Measure ID is 1522940, your URL will look like this:Under HTTP request header parameters, paste the accessKey and secretKey in their respective fields. See example above for steps on how to generate the API Keys in ClearPoint.
Once you are done, click OK
