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:
- 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.
(image original: https://blog.trello.com/hs-fs/hubfs/Imported_Blog_Media/okr_buffer-1024×512.jpg)