March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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?
Solved! Go to 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
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-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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
36 | |
31 | |
20 | |
11 | |
8 |
User | Count |
---|---|
53 | |
42 | |
28 | |
11 | |
11 |