Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Dynamic M query parameter not working

Hi All, I'm quite new for Power BI. As first, I have created a report to visualize the queue loads of a UiPath process. The query is working, it is gathering the successful / failed counts of items ...
Need Help
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
5 years ago

amitchandak  now I read a bit more after the directquery, but could not find if it is direct or import... but when I have created the blank query as data source. and there I'm using queries like this:

let
    Path = "/odata/QueueDefinitions?$filter=Name eq '" & in_QueueName & "'",

    Auth = Json.Document(Web.Contents(BaseUrl, [Headers=[#"Content-Type"="application/json"], Content=Json.FromValue(Credentials), RelativePath="/api/account/authenticate"])),
    Token = Auth[result],

    Source = Json.Document(Web.Contents(BaseUrl, [Headers=[Accept="application/json", #"Authorization"="Bearer " & Token], RelativePath=Path])),
    value = Source[value],
    ResultRecord = value{0},
    ResultId = ResultRecord[Id]
in
    ResultId

 

So really not sure, but for me it seems to be direct query.