facing error while dynamically passing a function (JobId) in URL (advance editor) in Dataset

[pinkukumar]

I am facing below error while dynamically passing a function (JobId)  in URL (advance editor) in Dataset and getting below error-

While trying to change the Type as Anonymous, Seeing below in data source settings-

JobId function code written for generating dynamic JobId-

Dataset code from advance editor-

If I am using hardcoded value for JobId then It's working fine -

URL="https://XXX.XXX.com/api/v3/job/19cf1416-afe2-00d0-8f2d-897d3a75ac00/results?offset=0&limit=500"

Can someone please help on this?, Thanks in Advance.
@powerquery
@

[pinkukumar]

Thanks @lbendlin . The Relative Path and Query options are working fine and It loads data for same. Below is the M-query code written for same. We are getting error while refreshing the preview.

let
URL="https://XXXXXX.XXXXXX.com/api/v3/job/",
headers=[Accept="application/json", #"Content-Type"="application/json", #"Authorization"="_dremio"&Token(), Method="GET"],
Source = Web.Contents(URL,[RelativePath=JobId()&"/results/",Headers=headers]),
response = Json.Document(Source),
#"Converted to Table" = Record.ToTable(response),
Value = #"Converted to Table"{2}[Value],
#"Converted to Table1" = Table.FromList(Value, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table1", "Column1", {"Testprocedure", "test_procedure_id", "Scopename", "ScopeId", "observation_title", "analytics_audit_procedures"}, {"Testprocedure", "test_procedure_id", "Scopename", "ScopeId", "observation_title", "analytics_audit_procedures"})
in
#"Expanded Column1"

But when I try to refresh preview, Getting below error-

Also not able to apply the changes because of the above error.

[pinkukumar]

I didn't find that the function as getting passed in URL in mentioned web-contents link-
Web.Contents - PowerQuery M | Microsoft Learn

It's not helpful.

[lbendlin]

please read the documentation again.  You need to use RelativePath and Query if you want to be able to refresh your data source from the Power BI Service.

[lbendlin]

Please use the RelativePath and Query options

Web.Contents - PowerQuery M | Microsoft Learn