Forum Discussion
Getting data from trello
Hi Anonymous
Do you use this url: https://api.trello.com/1/members/me/cards?key=AppKey&token=AccessToken to connect to Trello API?
Firsly, make sure Trello supports Rest API, then make sure the URL you use is correct and it is used to call the information of the cards. If all is correct, follow this blog: Using a REST API as a data source
It seems that you connect to this API successfully, and it will return Json. Some results of API will return Json File. You need to transform the Json file to Power BI Table. After table transformation, you will get the information of the cards.
For reference:
Converting JSON data into PowerBI table
Using Power BI with JSON Data Sources and Files
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
For anyone who wants to analyze Trello data in Power BI (without manual export of data from Trello or installation of 3rd party tools), I have released a comprehensive open-source project on GitHub with the Power BI report (pbip format).
The solution uses the built-in web connector in Power Query. The queries handle many of the Trello objects incuding boards, lists, cards, members, actions (card updates, comments, checklist completion). You get also the designed Semantic Model in Power BI with many of the Trello objects and several report pages that can help you analyze list completion rates, inactive members and card returns.
Learn more: here
GitHub repo: here