Forum Discussion
Web.Contents is not working with Scheduled Refresh [BUG]
The reason this isn't working is because you're generating the URL programmatically. For the most part, the URL will need to be a literal for refresh to work. If you need to construct an URL from a literal base path and a variable relative path, you could try specifying the base path as the first argument to Web.Contents and then using the RelativePath query option for the variable part. This has the limitation, though, that the base path by itself must be accessible or the "Test Connection" process will fail.
The reason this isn't working is because you're generating the URL programmatically. For the most part, the URL will need to be a literal for refresh to work. If you need to construct an URL from a literal base path and a variable relative path, you could try specifying the base path as the first argument to Web.Contents and then using the RelativePath query option for the variable part. This has the limitation, though, that the base path by itself must be accessible or the "Test Connection" process will fail.
Do you have any examples of a working parameterized web query where scheduled refresh is allowed? I am not finding any information on the "RelativePath" query option for the variable part.
If we are only allowed to specify static urls for scheduled refresh, it severely limits the functionality of the dashboards one can build.