Forum Discussion
I can't make schedule with parameters query
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?
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-in-power-query-and-power-bi-m-code/
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
2 Replies
v-jiascu-msftMicrosoft Employee
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
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-in-power-query-and-power-bi-m-code/
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