Trello data in Power BI

[learner03]

Can I please know the detailed process of getting trllo's data in Power BI. I looked into its documentation and did step by step to generate the key and token but it is saying invalid keys. 
Has someone successsfully been able to import data from trello. I am looking for no cost option  please.

[v-dineshya]

Hi @learner03 ,

Thank you for reaching out to the Microsoft Community Forum.

Hi @Ritaf1983 , Thank you for your prompt response.

Hi @learner03 ,  Could you please try the proposed solution shared by @Ritaf1983 ? Let us know if you’re still facing the same issue we’ll be happy to assist you further.

Regards,

Dinesh

[Ritaf1983]

Hi @learner03 
Please relate to the linked discussion:
https://community.fabric.microsoft.com/t5/Desktop/Get-Trello-Data-to-Power-BI-Dashboard-on-PBI-Pro/t...

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[learner03]

Also tried @v-yinliw-msft solution but I think the connector is not free

[learner03]

@Ritaf1983 I saw that yesterday and tried @DataChant solution but didn't know how to use the first step itself where it sayd copy repository. So I am stuck

[DataChant · Accepted solution]

Hi @learner03,

The solution is available for free on GitHub. The first step is download the files as a Zip. If you are new to GitHub, read how to download files here.

After you download the files, you can double click on the pbip using Power BI Desktop. Then you should change the parameters.

I hope this is clear 🙂

[learner03]

@DataChant I have been able to clone and I have entered paramenters but now I am getting this-

[v-dineshya]

Hi @learner03 ,

Thank you for the update. Please refer below community thread.

Solved: Trello rest api as a data source authentication is... - Microsoft Fabric Community

I hope this information helps. Please do let us know if you have any further queries.

Regards,

Dinesh

[v-dineshya]

Hi @learner03 ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

Regards,

Dinesh

[v-dineshya]

Hi @learner03 ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

Regards,

Dinesh

[DataChant]

Hi @learner03,

It seems that the issue is in the key and/or token you used. Did you follow Trello's user guide to obtain the key and token?

You may not have access to list your boards. Open Power Query Editor and see if you get access to any of the other tables. This may prove that you have partial access. Otherwise, make sure you entered the correct API Key and access token. If you don't get it to work, send me a private message, and I can join a live session to see what isn't working.

[learner03]

@DataChant Sent a private message. I think I am not generating the token and key correctly.

[learner03]

@DataChant  Thank you for your promt response and explaination. I will do as directed and if I get stuck, I will reach out to you.

Thanks again