How can I connect Trello to Power BI like a Web source? Edited

[Joseph Tello]

We tried this option at work but we don´t have success.

https://community.powerbi.com/t5/Community-Blog/Part-Two-Linking-Power-BI-to-Trello-deep-dive/ba-p/156709

Thanks for the help!

[Francis Peixoto]

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.

[Joseph LaRosee]

It looks like an authentication issue. 

[Rael Rodrigues]

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/

[Joseph LaRosee]

What did you do? When I tried I had the same issue.

[Rael Rodrigues]

try to follow the link and the next steps

[Joseph LaRosee]

It looks like it requires an open board unfortunately 

[Rael Rodrigues]

one more important thing, the visibility must be in Public

[Rael Rodrigues]

tell me if it works for you

[Joseph LaRosee]

Unfortunately I need to do it with a private board :(

[Rael Rodrigues]

you can use it with private in Public, people will see your trello only if they have your link