You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.
View groupJoin the community to find out what other Atlassian users are discussing, debating and creating.
We tried this option at work but we don´t have success.
Thanks for the help!
I managed to get this working with Authentication
I have setup parameters in powerbi/query for
This is an example of the code block for the power bi query
let
Source = Json.Document(Web.Contents("https://api.trello.com/1/boards/"&TrelloBoardKey&"/cards?key="&TrelloAPIKey&"&token="&TrelloAPIToken&"")),
#"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
If you want to get Card information you can use the
https://api.trello.com/1/boards/"&TrelloBoardKey&"/cards?
and for lists..
https://api.trello.com/1/boards/"&TrelloBoardKey&"/lists?
and there are others.
Getting your Keys
To get your API Key go to https://trello.com/app-key
To get your API Token, you get this once you have an API Key you can get a token
This sums it up.. https://developers.trello.com/page/authorization
References
https://community.powerbi.com/t5/Desktop/Trello-rest-api-as-a-data-source-authentication-issue/m-p/718010#M346519
https://blog.crossjoin.co.uk/2016/08/16/using-the-relativepath-and-query-options-with-web-contents-in-power-query-and-power-bi-m-code/
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hey thank you for this it worked perfectly.
But I have one issue when I try to export actions it only give 50 rows even though the json clearly has all of them (when you export the Trello board as a json).
Do you know of a way I can get it to bring in more than just 50 rows? It seems to be able to bring in data for every card when it’s set to “cards”, but not “actions”.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I know there is a limit to the number of items when you try to access it through the RestAPI. the number is 1000.
maybe there is a similar limit to the export?
or, maybe, you can export only the last actions done on the board because it doesn't export the history?
If you like to use the API, I can help you.
Nathan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
it is right, I did it with sucess.
you only need to go to the next step, like this link:
https://databackwriter.com/2017/03/15/getting-actual-trello-cards-into-power-bi/
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
you can use it with private in Public, people will see your trello only if they have your link
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,
thanks for the tip, very useful.
did you manage to Model it all?
it seems I'm still missing action dates and custom fields.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Using a JSON data source in PowerBI is usually quite common. What didn't work in your integration?
If you're using PowerBI, you could look into MS Flow as a lightweight service bus. Flow has connectors for both Trello and PowerBI that could simplify the integration setup. A more robust of feature rich integration via a service bus would require something like Mulesoft to be set up in the middle. Mulesoft would allow two-way one-to-many or many-to-one interactions between systems.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Community! My name is Brittany Joiner and I am a Trello enthusiast and Atlassian Community Leader. I'll be sharing with you a series of videos with my top tips on how to best use Trello...
Connect with like-minded Atlassian users at free events near you!
Find an eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.