Forum Discussion

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

blopez11
7 years ago
The first parameter to Web.Contents must be static
In your case try setting it to "https://api.trello.com/", then use the relative path option to add "1/boards/cExjoJEB/cards", and query option for the paremeters "key=<my key>a&token=<my token>"

The below reference helped me out quite a bit

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/

Good luck

blopez11

Super User

7 years ago

The first parameter to Web.Contents must be static

In your case try setting it to "https://api.trello.com/", then use the relative path option to add "1/boards/cExjoJEB/cards", and query option for the paremeters "key=<my key>a&token=<my token>"

The below reference helped me out quite a bit

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/

Good luck