I'd love to be able to link to Trello and be able to spin my cards in various ways. See number of open cards, number of cards assigned to members, etc.
16 Comments
- I too use Trello and find it a very easy and intuitive SCRUM project management tool to collaborate with our developers and testers. It's well reported that the reporting on Trello is below optimal however they do provide APIs for 3rd party developers. It would be great if the Power BI and Trello team could collaborate on delivering an out of the box dashboarding capability. Or alternatively, more services with Project Management tools in particular Agile/SCRUM optimised ones.
- Data from Trello boards can be exported to CSV and then imported into Power BI. You can then perform your queries against that data. Not ideal since it's not a live update of the Trello data, but it's one way to slice and dice your Trello stuff.
- Agree, Would be very usefull to get data directly from Trello. Now that Microsoft will reléase "ConnectorS" on O365 that allow to connect to Trello, maybe you can also add this feature to Power BI
- '@bradford, i would be great to see what you have done with the Trello API
- I've been able to do it via the API and I'm happy to share with you if you'd like. I've managed to query cards, members, boards and checklists (pretty much everything you'd want) and with merges have been able to create some cool tables.
- djnww
Impactful Individual
Of all the task management apps out there such as asana, swipes and basecamp, Trello is probably the most ideal candidate for Power BI. It makes sense as it uses a similar Tile and Dashboard function making the 2 very similar in functionality and looks. - Btw, if you need to get the data into Excel, there is a good site I just found, json-xls.com/json2xls, that converts the Trello JSON export to .xlsx format. This could easily be used to set up a data query. Though long-term, I do think a native connector would be really beneficial!
- Bradford Wills, can you share with me the dashboard, please? I'm looking for a way to connect Trello data with PBI and so far I haven't been able to do it live. Are you exporting JSON files and updating manually or is it live? If you could contact me, I'd appreciate ([email protected] or [email protected]) Thanks!
- '@Bradford Will, can you share the code you used in Power BI to query the Trello API?
- Hey @Bradford Wills, seems like you are in demand! Want some work? Ping me @digitalt
