Using the ClearPoint API to Integrate with Power BI
This article explains how to use the ClearPoint API to bring Measure data into Power BI.
Fernando Montenegro
13 steps
26 seconds
Clearpointstrategy
1
The ClearPoint API allows you to connect your ClearPoint account with other applications and data sources, helping you expand your reporting and analysis capabilities.
Step 1 — Select the Measure in ClearPoint
2
To retrieve Measure data through the ClearPoint API, you need the **Measure ID**.
3
# Step 1 — Select the Measure in ClearPoint To retrieve Measure data through the ClearPoint API, you need the **Measure ID**. ## Option A: Find the Measure ID in the URL 1. Navigate to the **Measure Detail Page** in ClearPoint. 2. Look at your browser’s address bar. 3. Locate the value after **objectId**. Example URL: https://app.clearpointstrategy.com/#/index/?object=measure&objectId=1522940&periodId=312499&scorecardId=154480 💡 In this example, the Measure ID is **1522940**.
4
## Option B: Display the Measure ID on the Detail Page 1. From the left navigation, click **Elements**. 2. Open **Measures**. 3. Select the Measure (e.g., *Revenue*).
5
1. Open the **kebab menu (⋮)** next to the Edit icon and select **Edit Layout**.
6
1. In the layout panel, locate the **Measure ID** field. 2. Drag and drop to place it where you want it. 3. Click **Save**.
7
💡 You will now see the Measure ID displayed directly on the Measure Detail Page.
Step 2 — Add an API Key for Power BI Integration
8
1. From the top navigation, click **Settings**. 2. Select **Integrations**.
9
1. Navigate to the **API Keys** tab. 2. Click the **Add API Key** (+) icon. 3. Enter a name such as **PowerBI**. - We recommend using a descriptive name for future reference. 4. Set an expiration date as needed. 5. Map the **API Key** to a user. 6. Click **Save**.
10
1. Select the newly created key and copy the **Access Key** and **Secret Key**. 💡 You will use these values when connecting Power BI to ClearPoint.
Step 3 — Integrate ClearPoint with Power BI
11
If you do not already have Power BI, you can download it [**here**](https://www.microsoft.com/en-us/download/details.aspx?id=58494).
12
## Connect Power BI to ClearPoint 1. Open **Power BI**. 2. Click **Get Data**. 3. Select **Web**.
13
1. In the dialog that appears, click **Advanced**. 2. In the **URL parts** field, enter the following endpoint, replacing `{measureId}` with your actual Measure ID: https://app.clearpointstrategy.com/api/v1/measures/{measureId}/measureData Example using Measure ID 1522940: https://app.clearpointstrategy.com/api/v1/measures/1522940/measureData 1. Under **HTTP request header parameters**, add: - **accessKey** → paste your Access Key - **secretKey** → paste your Secret Key 1. Click **OK**.
Using the ClearPoint API to Integrate with Power BI
This article explains how to use the ClearPoint API to bring Measure data into Power BI.
Fernando Montenegro
13 steps
26 seconds
Clearpointstrategy
1
The ClearPoint API allows you to connect your ClearPoint account with other applications and data sources, helping you expand your reporting and analysis capabilities.
Step 1 — Select the Measure in ClearPoint
2
To retrieve Measure data through the ClearPoint API, you need the **Measure ID**.
3
# Step 1 — Select the Measure in ClearPoint To retrieve Measure data through the ClearPoint API, you need the **Measure ID**. ## Option A: Find the Measure ID in the URL 1. Navigate to the **Measure Detail Page** in ClearPoint. 2. Look at your browser’s address bar. 3. Locate the value after **objectId**. Example URL: https://app.clearpointstrategy.com/#/index/?object=measure&objectId=1522940&periodId=312499&scorecardId=154480 💡 In this example, the Measure ID is **1522940**.
4
## Option B: Display the Measure ID on the Detail Page 1. From the left navigation, click **Elements**. 2. Open **Measures**. 3. Select the Measure (e.g., *Revenue*).
5
1. Open the **kebab menu (⋮)** next to the Edit icon and select **Edit Layout**.
6
1. In the layout panel, locate the **Measure ID** field. 2. Drag and drop to place it where you want it. 3. Click **Save**.
7
💡 You will now see the Measure ID displayed directly on the Measure Detail Page.
Step 2 — Add an API Key for Power BI Integration
8
1. From the top navigation, click **Settings**. 2. Select **Integrations**.
9
1. Navigate to the **API Keys** tab. 2. Click the **Add API Key** (+) icon. 3. Enter a name such as **PowerBI**. - We recommend using a descriptive name for future reference. 4. Set an expiration date as needed. 5. Map the **API Key** to a user. 6. Click **Save**.
10
1. Select the newly created key and copy the **Access Key** and **Secret Key**. 💡 You will use these values when connecting Power BI to ClearPoint.
Step 3 — Integrate ClearPoint with Power BI
11
If you do not already have Power BI, you can download it [**here**](https://www.microsoft.com/en-us/download/details.aspx?id=58494).
12
## Connect Power BI to ClearPoint 1. Open **Power BI**. 2. Click **Get Data**. 3. Select **Web**.
13
1. In the dialog that appears, click **Advanced**. 2. In the **URL parts** field, enter the following endpoint, replacing `{measureId}` with your actual Measure ID: https://app.clearpointstrategy.com/api/v1/measures/{measureId}/measureData Example using Measure ID 1522940: https://app.clearpointstrategy.com/api/v1/measures/1522940/measureData 1. Under **HTTP request header parameters**, add: - **accessKey** → paste your Access Key - **secretKey** → paste your Secret Key 1. Click **OK**.
