I'm a flow newbie, so go easy
I've built a PowerBI report connecting to the json file from a trello board (using this excellent tutorial here). It works great, but involves manually downloading the json file to update it.
The way I do the download is to use the URL from my trello board, with a '.json' at the end. I can then save that page as a json file and point my power BI report to that. It works perfectly. But it's still manual, so I'd like to automate it, but I'm struggling.
Any help on how I could get flow to regularly get the json file and save it (either to onedrive or sharepoint) that would be really great. I could then schedule the PowerBI refresh as normal.
Thanks in advance 🙂
Hi @desreed ,
Please try using HTTP action to get JSON File.
Please take a try.
Hi Barry @v-bacao-msft
Thanks for the advice. I had tried that before posting, but have tried again and checked through with the details you've kindly given in your advice. Unfortunately it fails. For the HTTP step, I get an error message:
Status : 401
Body : Unauthorised permission requested
Does flow have different levels of access for different accounts? e.g. is the http step something that you need a higher level of microsoft account to access? If so, that may be it. I don't know what level access I have as it's through the organisation I work for in the UK.
Thanks again for your advice so far.
Hi @desreed ,
I tested it on my side. If the Board are private, I can't get the data.
For reference, the board I used for testing here is public.
Thank you Barry , @v-bacao-msft
The board I have is a private one. I'm guessing that's the issue then with this solution.
Does anyone know of a way to get the data from a private board in an automated way? I don't have a paid-for subscription to trello, just the free service.
Check out the winners of the recent 'Can You Solve These?' community challenge!
Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.
Features releasing from October 2020 through March 2021
Fill out a quick form to claim your user group badge now!