Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago

Dynamic Data Source Error in Power Query

I'm getting Dynamic Data Source error in Power Query as below : "Some data sources may not be listed because of hand-authored query"   and below is my code; How should I modify it? let BaseUr...
lbendlin's avatar
lbendlin
Super User
2 years ago

Please read the documentation of Web.Contents - you need to use the Query parameter.

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago

Yeah, I know  but unfortunately I don't know how exactly I should do that. Can you modify the M code that I've mentioned above?

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    you would need to add a second parameter to the GetJSON function.

     

    GetJson = (Url,q) =>
let Options = [Headers=[ #"Authorization" = "Token"],Query=q],
RawData = Web.Contents(Url, Options),
Json = Json.Document(RawData)
in Json,