Forum Discussion
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...
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?
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,