Analyzing Trello boards in Power BI

by | Sep 30, 2025 | Uncategorized | 0 comments

Introducing Trello-Power-BI: Open Source Connector to analyze your Trello boards in Power BI

I am excited to share a new open-source project on GitHub: Trello-Power-BI.
This repository enables Microsoft Fabric, Power BI, and Power Query users to seamlessly connect to their Trello boards and analyze activities with Power Query DAX and Power BI reports. I will share more content over time, including tutorials with the implementation in dataflows Gen1 and Gen2 and how this can be translated into Python on Fabric as well.

To support this project, please give it a Star on GitHub.

What’s Inside

  • A ready-to-use Power BI Project file (.pbip) that connects to Trello via API.
  • Power Query scripts to extract board details, card actions, checklists, and comments.
  • A semantic model optimized for analyzing collaboration patterns and productivity.
  • Few report pages that analyze members inactivity and card returns (This may or may not be relevant to you, but it was implemented as part of a real project for a customer, so you have the logic here, without the customer's Trello data).

Here is a screenshot from one of the report pages in the repo (after you load it with your data. It's empty in the repo). In this page, the comments of members in cards are analyzed. When members don't comment for 3 days, their task is marked as inactive. You can select the specific member and view their inactive tasks. You can even navigate from the hyperlinks in Power BI to the relevant tasks in Trello.

In this example, you can analyze card returns. When cards are moved back to their original list (due to incompletion of tasks), you can analyze which lists have cards with 3+ returns or what's their completion rate, as reflected by the card moves (When you don't mark cards as completed, you can measure their completion by analyzing the history of their movement through the different lists).

How This Open Source Works

  1. Clone opr download the repo and open Trello.pbip in Power BI Desktop.
  2. Edit parameters to provide your Trello API Key and Token. (Learn how to get them)
  3. Refresh the report and explore your Trello data.
  4. Optionally limit imported Trello Actions (e.g., last 30 days) to improve performance.

Why It Matters

Trello is a fantastic tool for managing projects, but it doesn't come with the level of analytics you can achieve in Power BI. With this project, you can:

  • Track card movement trends
  • Monitor team activity and collaboration
  • Identify bottlenecks and completed tasks
  • Blend Trello with other enterprise datasets in Power BI or Microsoft Fabric

Get Started

???? Visit the repo: github.com/DataChant/Trello-Power-BI.
???? Contribute, fork, or customize to fit your use cases.

Need help tailoring it for your organization? Contact us at support@datachant.com.

Leave a Reply