topic Re: Getting data from trello in Developer

Getting data from trello

Anonymous — Thu, 01 Jul 2021 20:45:10 GMT

I am making a call to the Trello API, trying to get information contained in the Trello card,
I am mainly interested in knowing the date this card was born. I am making the call from Power Bi and
I have it connected through the web with a Json file, do not download the file, it is linked to Trello.
Do you know if there is the correct way to do this? I have tried in various ways and none have been able to obtain this information.
https://api.trello.com/1/members/me/cards?key=AppKey&token=AccessToken

This call is supposed to return the information of the cards that I have access to, but when I do the query it returns an empty array. Please if you know how to solve it, I would greatly appreciate it.

Get data from trello

Anonymous — Thu, 01 Jul 2021 20:42:24 GMT

Estimados,

Estoy realizando una llamada a la API de Trello, intentando obtener información contenida en la tarjeta de Trello, principalmente me interesa conocer la fecha en que nació esta tarjeta. La llamada la estoy realizando desde Power Bi y lo tengo conectado a través de la web con un archivo Json, no descargue el archivo, este está enlazado con Trello. Saben si existe la forma correcta de hacer esto? Lo he intentado de diversas formas y ninguna ha logrado obtener esta información.

https://api.trello.com/1/members/me/cards?key=AppKey&token=AccessToken

Esta llamada se supone debe devolver la información de las tarjetas a las que tengo acceso, pero cuando realizo la consulta devuelve una matriz vacía.

Por favor si saben como resolver se los agradeceria mucho.

Re: Getting data from trello

Anonymous — Mon, 05 Jul 2021 09:18:03 GMT

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.

Re: Getting data from trello

JamesLee94 — Wed, 21 May 2025 10:05:26 GMT

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.

Re: Getting data from trello

DataChant — Wed, 01 Oct 2025 03:14:30 GMT

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