Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.