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.
Getting data from Trello means dealing with nested JSON and sometimes paging through a lot of results. Make sure your API tokens are working and keep an eye on rate limits so you don’t get blocked. You’ll likely need to flatten and clean the data in Power Query or whichever tool you’re using. If you want to avoid writing code, tools like Skyvia can handle syncing Trello data to a database or BI tool, taking care of paging and authentication for you.