Web-Api stops my dataset from refreshing

There has been alot written about this in the community

You likely will need to break up the first parameter you are passing to webcontents to where the first paramter is just the base url, then use a combination of the relative path, query and header options to pass in the rest of your url

There are alot of articles on this that you can find searching the web, but I've included one below that I used:

https://blog.crossjoin.co.uk/2016/08/16/using-the-relativepath-and-query-options-with-web-contents-in-power-query-and-power-bi-m-code/