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 replicate the below method to implementing query folding in using service now rest API in power bi desktop
https://sqldusty.com/2020/05/20/power-bi-incremental-refresh-with-web-api-data-source/
Service now encodes the date parameter like this :-
(dtquery as text)=>
let
Source= Json.Document(Web.Contents("https://servicecentral.xxx.com/api/now/table/prolem",
[Query=sysparm_query=sys_created_on%3E%3Djavascript%3Ags.dateGenerate(dtquery)]))
#"Converted to Table" = Table.FromList(Pagination, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
in
#"Converted to Table"
what is wrong here?
@Anonymous - You are missing a comma after your first line (Source)
(dtquery as text)=>
let
Source= Json.Document(Web.Contents("https://servicecentral.xxx.com/api/now/table/prolem",
[Query=sysparm_query=sys_created_on%3E%3Djavascript%3Ags.dateGenerate(dtquery)])),
#"Converted to Table" = Table.FromList(Pagination, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
in
#"Converted to Table"
@Greg_Deckler thanks for the reply, My query is returning the same error even after putting a comma as you mentioned.
[Query=sysparm_query=sys_created_on%3E%3Djavascript%3Ags.dateGenerate('2020-05-01'%2C'00%3A00%3A00')])),
the red'%' value is where its showing as "Token Comma Expected"
@Anonymous - Pretty sure your syntax for the Query parameter is way off.
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.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |