I can't make schedule with parameters query

[nsimonov]

Hello!

I Need Help.

I have the next code:

let
TextString = "https://fornex.com/api/vps_stat/34-172757/cpu/2017-09-09--2017-09-10.json?apikey=xxxxxx",
Source = Json.Document(Web.Contents(TextString))
in
Source

The settings for automate update in PowerBI Web interface is ok.

But, if I change TextString to use of variables, I have a Error: You can not schedule an update for this dataset because one data source or more than one does not currently support the update.

Here it is:

let
date = #date(2017,9,9),
TextString = "https://fornex.com/api/vps_stat/34-172757/cpu/" & Date.ToText(date, "yyyy-MM-dd") & "--" & Date.ToText(date + #duration(1,0,0,0), "yyyy-MM-dd") & ".json?apikey=xxxxxx",
Source = Json.Document(Web.Contents(TextString))
in
Source

How I can to resolve this problem?

[v-jiascu-msft]

Hi @nsimonov,

I find out some posts that have the same issue. There are solutions in these posts. Please check it out if they can solve your problem.

Web-Contents-is-not-working-with-Scheduled-Refresh-BUG

https://msdn.microsoft.com/en-us/library/mt260892.aspx

Can-t-schedule-a-refresh-for-Web-data-matching-a-function-with-a

Refreshing-queries-with-functions-doens-t-work

Best Regards!

Dale

[nsimonov · Accepted solution]

Thank you!

It helps me to resolve my problem.

All works is right.

Problem resolve in a RelativePath

This is url to wonderful solution: https://blog.crossjoin.co.uk/2016/08/16/using-the-relativepath-and-query-options-with-web-contents-i...

This is my workin code:

let
date = #date(2017,9,9),
TextString = "/api/vps_stat/34-172757/cpu/" & Date.ToText(date, "yyyy-MM-dd") & "--" & Date.ToText(date + #duration(1,0,0,0), "yyyy-MM-dd") & ".json",
Source = Json.Document(Web.Contents(
"https://fornex.com",
[
     RelativePath=TextString,
     Query=
        [
             apikey="xxx"
       ]
]
))
in
    Source