Forum Discussion
Helper IScheduled refresh on Web.Contents that has calculated date parameter
Thanks for this pointer Anonymous , as per usual the MS documentation didn't quite give the full explanation I needed (ie how to stucture for multiple query paramaters). But I found a couple of really good blogs by Chris Webb that helped me and also explained why splitting the query into component parts is needed for the service.
I also had the added complication that my query parameters all started with a $ ($select=), which required me to wrap them in quotes (eg #"$select" = ).
Only problem I have now is that the I can't get the authentication to work on the refresh on the service (says the credentials are invalid even though when I edit the credentials and it tests the connection, it says they've worked).
Super UserPlease follow the documentation. Use RelativePath and Query parameters. https://learn.microsoft.com/en-us/powerquery-m/web-contents#example-1
Helper IThanks for this pointer Anonymous , as per usual the MS documentation didn't quite give the full explanation I needed (ie how to stucture for multiple query paramaters). But I found a couple of really good blogs by Chris Webb that helped me and also explained why splitting the query into component parts is needed for the service.
I also had the added complication that my query parameters all started with a $ ($select=), which required me to wrap them in quotes (eg #"$select" = ).
Only problem I have now is that the I can't get the authentication to work on the refresh on the service (says the credentials are invalid even though when I edit the credentials and it tests the connection, it says they've worked).