Blog Post

Power BI Community Blog
1 MIN READ

Part One: Linking Power BI to Trello (overview)

factgasm's avatar
factgasm
Icon for Advocate I rankAdvocate I
9 years ago

A big help when measuring Trello is that Power BI knows something about Trello that you may not: Behind every board on Trello is a JSON file. Don’t worry if that makes no sense, let Power BI do that for you.

 

This is what a Trello board looks like ordinarily:

This is what a Trello board looks like as JSON:

The two pictures are of the same thing! Power BI lets you utilise that.

Next, we use this feature of Power BI to connect to an actual Trello board.

Updated 9 years ago
Version 3.0

5 Comments

  • vicestcha's avatar
    vicestcha
    Regular Visitor

    I reed your blog for creating a Data model based on the trello .json file. And is really cool, but I continue wihtout understanding how I can make the visualization part. Could you continue with the "Part two" of your blog? I found it very usefull.

     

    thanks for your time.

  • Good afternoon, can you make the .pbix file available with all modeling tables including their relationships?
    Thank you.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Problem about this approach is, that this will not refresh uploaded reports in most cases as it works only for public boards. For private boards, you will need to use the Trello API instead. See in our blog. Blog | Ceteris AG

    cheers, Tarek

  • DataChant's avatar
    DataChant
    Icon for Most Valuable Professional rankMost Valuable Professional

    For anyone who wants to analyze Trello data in Power BI (without manual export of data from Trello or installation of 3rd party tools), I have released a comprehensive open-source project on GitHub with the Power BI report (pbip format).

     

    The solution uses the built-in web connector in Power Query. The queries handle many of the Trello objects incuding boards, lists, cards, members, actions (card updates, comments, checklist completion). You get also the designed Semantic Model in Power BI with many of the Trello objects and several report pages that can help you analyze list completion rates, inactive members and card returns.

     

    Learn more: here

    GitHub repo: here