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.