Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
what I want to do is to hand over the date from last year (-365 days) to a URL as text for my web source. As I'm pretty new to power query I tried this:
Source = Json.Document(Web.Contents("https://myurl.com/visits?startDate=" & Text.From(Date.Year(Date.AddDays(DateTime.LocalNow,-365))) & "-" & Text.From(Date.Month(Date.AddDays(DateTime.LocalNow,-365))) & "-" & Text.From(Date.Day(Date.AddDays(DateTime.LocalNow,-365)) & "&limit=500")))
But that does not work. Whats the best way to solve this?
Many thanks in advance!
Solved! Go to Solution.
Please try this syntax instead.
= Json.Document(Web.Contents("https://myurl.com/visits?startDate=" & Date.ToText(Date.AddYears(Date.From(DateTime.LocalNow()), -1), "yyyy-MM-dd") & "&limit=500"))
Pat
Please try this syntax instead.
= Json.Document(Web.Contents("https://myurl.com/visits?startDate=" & Date.ToText(Date.AddYears(Date.From(DateTime.LocalNow()), -1), "yyyy-MM-dd") & "&limit=500"))
Pat
Thank you!
Hi,
In your formula try replacing DateTime.LocalNow to DateTime.LocalNow().
Hi,
that was one of my mistakes, thanks!