Forum Discussion
Automatically refresh JSON feed
Hi I’m looking to automatically refresh a webhose.io JSON feed in Power BI. Webhose.io gives you an ‘endpoint’ and I’ve managed to feed this into Power BI successfully via the JSON connecto...
Hi Ben_Nash,
After research, there is no "looping" in Power Query, only recursion. And I list some blog and threads below. Hope it it's helpful.
Do … While loop with Power BI (M language)
How to automate/parameterize/loop power query?
Be Fitbit BI Developer in Few Steps: Step 2 Loop Through All CSV Files
In addition, you can also go to the Power Query forum to get dedicated support.
Best Regards,
Angelia
Hi Angelia
Thanks - I'll look into options outlined! I'm thinking the other way to incorporate the webhose.io JSON feed into Power BI is via Power BI's REST APIs?
Thanks
Ben
Hi Ben_Nash.
More knowloedage about Power BI's REST API, you can post your thread in Power BI develper to get dedicated support.
Thanks,
Angelia