Forum Discussion

ptmuldoon's avatar
ptmuldoon
Resolver I
3 years ago

Loop and Combine Web.Contents Query

I am trying to pull data that where I need to set the a 'SiteTag' number.  And I have a list of 50 'SiteTag' numbers.   Is there a way that I can loop and combine them all into 1 table?  It will be...
Need Help
ptmuldoon's avatar
ptmuldoon
Resolver I
3 years ago

Thansk for the help and feed back.  

I'mnt sure if that article will help as I'm not actually looping pages of website, but querying 50+ separate API calls/URLS to get the JSON data.

 

But I did find this tutorial in using a custom function, and do have this working.  I still need to think the best way I want to generate the list of URLS, but this did help me here.

 

https://community.powerbi.com/t5/Community-Blog/Import-JSON-files-from-multiple-URLs-into-Power-BI-Desktop-and/ba-p/1615660