Multiple scripted queries to API

Hi All, Noob PowerBI user here..    I have a web hosted API to query collect some measurements. I can get to query to return data, but the API has some limitations. It will only allow 1000 values p...