Skip to main content

 

Planview Customer Success Center

Advanced Reporting API: Connecting LeanKit with Power BI

This article explains how to connect your LeanKit account's information with Microsoft Power BI for the purpose of analytics and reporting.

Prerequisites:
  1. Install the Microsoft Power BI Desktop application.
  2. Download the LeanKit PowerBI Template (V18)
  3. Create a LeanKit API token.

How To Connect Your LeanKit Account With Power BI

  1. Navigate to your LeanKit account and click your user profile.
  2. Click API Tokens, and then create an API token for your LeanKit user as shown in the following animation:

               

    Click to expand or shrink

               

  3. Click Copy Token for the API token that was generated.
  4. Download the LeanKit Power BI template file.
  5. Open the LeanKit Power BI template file in Power BI Desktop.
  6. Enter your LeanKit account URL and the API token from step 2, as shown in the following image:

               

    Click to expand or shrink

               

Connecting LeanKit with Power BI Demo