Access the API - Using the ClearPoint API to Integrate with PowerBI | Scribe

    Access the API - Using the ClearPoint API to Integrate with PowerBI

    • Fernando Montenegro |
    • 0 step |
    • 2 minutes
    Start by logging into ClearPoint Strategy at [app.clearpointstrategy.com/#/home](http://app.clearpointstrategy.com/#/home)

    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: “https://app.clearpointstrategy.com/#/index/?object=measure&objectId=1522940&periodId=312499&scorecardId=154480” In this example, the Measure ID is 1522940
    - 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](https://www.microsoft.com/en-us/download/details.aspx?id=58494).
    - 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. https://app.clearpointstrategy.com/api/v1/measures/{measureId}/measureData \ Following the example above, the Measure ID is 1522940, you will have something like this: \ https://app.clearpointstrategy.com/api/v1/measures/1522940/measureData - 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**
    This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe