Data sources currently don't support refresh issue on API

[smnthdcstr]

I am connecting to api and i am getting an issue: You can't schedule refresh for this dataset because the following data sources currently don't support refresh

I am not sure about what happened since I used an api before and it is not returning this issue. I also setup a scheduled refresh before. 

Here is my code below (App ID and key are parameterized): 

enddate = Date.ToText(Date.AddDays(Date.From(DateTime.FixedLocalNow()),-1), "yyyy-MM-dd"),
url = "https://sampleapi.net/api/metrics/",
query = "/dataTable?startDate=2020-03-01&endDate=" & enddate & "&userText=Text",
Source = Json.Document(Web.Contents(url & AppID & query, [Headers=[#"x-api-key"=AppKey]]))

I tried using variables for other components of the url but it still didn't work. 

I wanna try the relative path but it still wouldn't work, I don't know what I'm doing wrong. 

[v-chuncz-msft]

@smnthdcstr 

You may check if the posts below helps.

• https://community.powerbi.com/t5/Power-Query/Web-Contents-Desktop-to-Service/m-p/1037219#M35076
• https://community.powerbi.com/t5/Service/Re-Query-contains-unsupported-function-Function-name-Web/m-...

[smnthdcstr]

@v-chuncz-msft i did that but it keeps returning an error. it was my first time doing that so im not sure how to format it on my api url