Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Help creating dynamic parameters for power query

Hi all,  Need help in creating a dynamic parameter to my query in power bi query as below: (dtquery as text) => let url="https://<instance>.xxx.com/api/now/table/incident?sysparm_display_value=tr...
Need Help
Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi Anonymous 

 

So there is a clear indication that the below part is wrong.

[Query=sysparm_query&"="&sys_created_on&STARTSWITH&dtquery]
most probably you have not defined sysparm_query anywrer in power query.

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Mariusz Thanks for your reply, But if you see my URL I am actually using the parameter in the query:

 

(dtquery as text) =>
let
url="https://<instance>.xxx.com/api/now/table/incident?sysparm_display_value=true&sysparm_exclude_reference_link=true&sysparm_limit=1&sysparm_query=sys_created_onSTARTSWITH2020-07-08",
Source = Json.Document(Web.Contents(url,[Query=sysparm_query&"="&sys_created_on&STARTSWITH&dtquery]))