I'm working on a few Power BI reports after months of building them up on Excel using Power Query. So far I was using the downloadable Json board file. When migrating to PBI, I've found the option to use the API, however, this has proven to be quite restrictive when compared to the JSON file.
As there is the web JSON file (accessed through the browser, not by download), I've been trying to connect to it instead, in order to get more of a live result.
The web JSON file does work fine from public boards, but I would like to use it for private boards. Power BI asks me to provide credentials, but the API keys don't work. What would be the best way to get this out of the way?
Thanks for reaching out!
I'm not familiar with Power BI reports, but it sounds like you need your API key and token, which you can get here: https://trello.com/app-key.
Also, your use-case sounds familiar to another user's and they got this connection to work following these steps: https://community.atlassian.com/t5/Trello-questions/How-can-I-connect-Trello-to-Power-BI-like-a-Web-source/qaq-p/664331#M15820
I hope that helps!
All the best,
The Trello Team
Thanks for your reply, unfortunately, as I mentioned in my question, although this does work, it is too limited. Instead of accessing it through Trello's API, I would like to access the complete web JSON file (i.e. https://trello.com/b/<boardid>.json)
I can access this when the board is in 'public' mode, but when I switch it to 'private', I'm being asked for an authentication which I do not have.
Congratulations to @Laura Holton , our latest winner of Taco Tuesday! And thanks to @Kristján Geir Mathiesen for sharing the picture of Taco having fun with his new friend B...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events