dynamic data sources aren't refreshed in the Power BI service

[WTAS80486]

I am using this in a query

= let
ParameterDate = Date.ToText(DateTime.Date(DateTime.LocalNow()), "yyyyMMdd"),
UrlTemplate = "https://www.abcd.com/content/cdr/html/{date}_dam_spp.html",
Url = Text.Replace(apiUrlTemplate, "{date}", ParameterDate),
response = Web.Contents(apiUrl),
source = Text.FromBinary(response)
in
source

But power Bi service gives this error

[ImkeF]

Hi @WTAS80486 ,
that's difficult. But maybe relative path works here:
Chris Webb's BI Blog: Using The RelativePath And Query Options With Web.Contents() In Power Query An...