Forum Discussion
I can't make schedule with parameters query
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
Microsoft EmployeeHi 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