Part One: Linking Power BI to Trello (overview)

[factgasm]

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:

• Navigate to: https://trello.com/b/oBaLsnbq
• It should look something like this:

This is what a Trello board looks like as JSON:

• Navigate to https://trello.com/b/oBaLsnbq.json (this is the same as the above but with .json on the end), it should look like this:

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.

[vicestcha]

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.

[factgasm]

Thanks @vicestcha, the blog continues on my website here: it goes through a few iterations. At the end of it you will have a full data model that you can throw any of Power BI's increasingly wonderful visualisations at: https://lookatyourdata.org/2017/03/15/connecting-trello-to-power-bi-for-the-first-time/

[julianorodrigs]

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

[Anonymous]

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