Live Trello data source (not JSON export)

[dean_rowntree]

Hi all

I'm a relatively new user to PowerBI and Get&Transform in Excel, but I'm genuinely intrigued and excited by the possibilities that PowerBI can offer.

I would like to be able to make my data source be a private Trello board, so that my dashboard in PowerBI would be constantly up to date. I do know that I can export Trello to JSON and make that my data source, but of course, that is static data.

So far Trello is not a featured service, but I wondered if there was a way to do it, considering I'm the admin of the Trello board and have access to the API key and tokens etc.

Any help and advice is greatly welcomed.

[v-yuezhe-msft · Accepted solution]

@dean_rowntree,

Based on my research, Trello provides rest api to access its data. You can use web connector in Power BI Desktop to connect to the Trello api. There is an web url example for your reference.

https://api.trello.com/1/boards/560bf4298b3dda300c18d09c?fields=name,url&key={YOUR-API-KEY}&token={A...}

You can check more details in the following blog and similar thread.
https://developers.trello.com/reference/#introduction
https://community.atlassian.com/t5/Trello-questions/Trello-Rest-API-to-get-all-Trello-cards-which-us...

Regards,
Lydia

[dean_rowntree]

@v-yuezhe-msft thank you very much for the information, a lot to get me started.