Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am trying to use a web site which returns json as the source for a table and due to the amount of data am trying to implement incremental refresh. I am attempting to use the string versions of the parameters (RangeStart and RangeEnd) in the command but I get a Token Comma Expected on the last like befor IN. Can anyone point me to where I am wrong?
let
strRangeStart = DateTime.ToText(RangeStart,[Format="yyyy-MM-dd"]),
strRangeEnd = DateTime.ToText(RangeEnd,[Format="yyyy-MM-dd"]),
Source = Json.Document(Web.Contents("https://volt0328.attendanceondemand.com/mobile/mssrestba.aew/v1/employees/paydes/daily/detail?hyperQ... Employees&periodSel=custom&from=" & strRangeStart & "to=" & strRangeEnd & " [Timeout=#duration(0,0,30,0)]))"
in
Source
Solved! Go to Solution.
Hi @MStile
You may try this. This doesn't have syntax error.
let
strRangeStart = DateTime.ToText(RangeStart,[Format="yyyy-MM-dd"]),
strRangeEnd = DateTime.ToText(RangeEnd,[Format="yyyy-MM-dd"]),
Source = Json.Document(Web.Contents("https://volt0328.attendanceondemand.com/mobile/mssrestba.aew/v1/employees/paydes/daily/detail?hyperQ... Employees&periodSel=custom&from=" & strRangeStart & "&to=" & strRangeEnd, [Timeout=#duration(0,0,30,0)]))
in
Source
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hi @MStile
You may try this. This doesn't have syntax error.
let
strRangeStart = DateTime.ToText(RangeStart,[Format="yyyy-MM-dd"]),
strRangeEnd = DateTime.ToText(RangeEnd,[Format="yyyy-MM-dd"]),
Source = Json.Document(Web.Contents("https://volt0328.attendanceondemand.com/mobile/mssrestba.aew/v1/employees/paydes/daily/detail?hyperQ... Employees&periodSel=custom&from=" & strRangeStart & "&to=" & strRangeEnd, [Timeout=#duration(0,0,30,0)]))
in
Source
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Your approach should work. But you need to add the "&" back in. Try this instead.
let
strRangeStart = DateTime.ToText(RangeStart,[Format="yyyy-MM-dd"]),
strRangeEnd = DateTime.ToText(RangeEnd,[Format="yyyy-MM-dd"]),
Source = Json.Document(Web.Contents("https://volt0328.attendanceondemand.com/mobile/mssrestba.aew/v1/employees/paydes/daily/detail?hyperQ... Employees&periodSel=custom&from=" & strRangeStart & "&to=" & strRangeEnd, [Timeout=#duration(0,0,30,0)]))"
in
Source
Pat
This would be the original code which works for retrieving data but not for incremental refresh
let
Source = Json.Document(Web.Contents("https://volt0328.attendanceondemand.com/mobile/mssrestba.aew/v1/" & "employees/paydes/daily/detail?hyperQuery=All Employees&" & "periodSel=custom&from=2018-01-02&to=2018-02-01", [Timeout=#duration(0, 0, 30, 0)])),
in
Source
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.