Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

JSON Export - Confused about List data


I'm testing the export to JSON option to create a Power BI dashboard. I have created a new test board in Trello so I can understand what has been created in the board.

I have created 3 Lists (columns), named

  • Leads/Ideas
  • Live Projects,
  • Lost/Closed/Gone Cold

I have created a new card and placed it into the Live Projects column. However, when I do the JSON export, it implies the card is also associated with the other 2 columns. I'm confused why this would be and it prevents me from being able to use filters correctly in Power BI.

Why isn't the card only related to the column/list it is currently in? (particularly if the card has never been in any other column before?)




Thoughts and help appreciated!



1 answer

0 votes
Antonio Panea Community Leader May 17, 2021

Hi @slynch ,


Nice to meet you!It could work for you exporting in anny other format? With Trello Business Class I think you have the chance.

I do not know what kind of information you need to get in Power BI. Trello in Business Class has also Dashboards which could give you some infomation with graphics about your board.

Moreover if you are focused in something more related with business and Deal Values you can try Crmble Power-Up (It is free) which also have interesting Dashboard from a business /productivity perspective. Also it is possible to export all your data in Spreadsheet and CSV format.

Hi Antonio,

Thanks for the reply. I cant export in any other format as I am on the free tier. I was hoping someone with more intimate knowledge of how Trello works, could explain why a card would have multiple values of belonging to more than one list, despite the card only ever being in one list (Live Projects). 

Hope I'm explaining this correctly!



Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Trello

Taco Tuesday: New years' resolutions with Trello

Congratulations to @Laura Holton , our latest winner of Taco Tuesday! And thanks to @Kristjan Geir Mathiesen - Origo for sharing the picture of Taco having fun with his new friend...

378 views 15 17
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you