Skip to main content
All CollectionsIntegrateAccess The API
Access the API - Using the ClearPoint API to Integrate with PowerBI
Access the API - Using the ClearPoint API to Integrate with PowerBI

This article shows how to integrate ClearPoint API with PowerBI.

F
Written by Fernando Montenegro
Updated over 8 months ago

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

Did this answer your question?