Connecting Private Trello Board to Power BI (without the API)

In theory, any private Trello board will connect with Power BI by using the Trello API. In practice this can get quite technical and, frankly, off-putting.

One way to get around this is to work with an offline version of the Trello Board.

When in Trello click on Show Menu:

In the menu click on More…

Then click on Print and Export., then Export JSON

Export the file.

Within Power BI press Get Data but instead of choosing Web, choose JSON. Upload the file you just exported.

From this point on the file will behave exactly as the web connected version with the downside that it is not 100% live. To refresh the data, you would need to export back over the top of the original file.




(image original:

One comment

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s