Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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 connector, but this only gives you the first 100 articles:
You need to keep adding the ‘next’ code in order to get the next 100 articles:
"totalResults": 38544,
"moreResultsAvailable": 38444,
"next": "/filterWebContent?token=cea99d95-447a-4aa9-955b-05a55c1a9f32&format=json&ts=1510365182000&q=%22donald+trump%22+language%3Aenglish&sort=crawled",
Is it possible to write a script in Power Query that allows you to automatically 'cycle' through all articles?
Any assistance appreciated!
Thanks
Ben
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
65 | |
63 | |
52 | |
37 | |
36 |
User | Count |
---|---|
79 | |
67 | |
60 | |
45 | |
45 |