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.
Features releasing from October 2020 through March 2021
We are excited to announce the launch of Power Virtual Agents Community. Check it out now!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!