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.
I have the following query which works, however the API is very slow, and if I try to increase the date range it times out:
Solved! Go to Solution.
Json.Document(Web.Contents("https:///api/v2/",[RelativePath="analytics-stream?startDate=" & Date.ToText(RangeStart, "yyyy-MM-dd") & "&endDate=" & Date.ToText(RangeEnd, "yyyy-MM-dd") &"&code=01",Timeout=#duration(0, 0, 30, 0)]))
Json.Document(Web.Contents("https:///api/v2/",[RelativePath="analytics-stream?startDate=" & Date.ToText(RangeStart, "yyyy-MM-dd") & "&endDate=" & Date.ToText(RangeEnd, "yyyy-MM-dd") &"&code=01",Timeout=#duration(0, 0, 30, 0)]))
**bleep** I was close 😂
Thank you!