Forum Discussion

wabanek's avatar
wabanek
Frequent Visitor
7 years ago
Solved

Trello rest api as a data source authentication issue

Hi All,    I have managed to get data from Trello rest api to my desctop report but when I published I get authentication 400 error - The credentials provided for the Web source are invalid. Not su...
Need Help
jeremyking77's avatar
jeremyking77
Helper I
7 years ago

Just to add onto what blopez11 said (so it does work)

 

Ive managed to get this working with Authentication

 

I have setup parameters in powerbi for

  • The API Key
  • The API Token
  • The board key you want to get information from

This is an example of the code block for the M code

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.

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 from the same page


This sums it up..  https://developers.trello.com/page/authorization