Forum Discussion

adam_cogswell's avatar
adam_cogswell
Regular Visitor
9 years ago
Solved

JSON query based on another query

Hi,   New to PowerBI, and having what is probably a simple problem but can't seem to get it figured. I am trying to load JSON data and I've got one query working like a charm, transformed into a ta...
Need Help
  • dkay84_PowerBI's avatar
    dkay84_PowerBI
    9 years ago

    Sorry I ommitted a "let".  See below:

     

    let function = (ID as text) => let
    Source = Json.Document(Web.Contents("https://api.provider.com/survey_results?survey_id=" & ID,
        [Headers=[Authorization="Bearer ACCESS_TOKEN", Allow="application/json", #"NGIN-API-VERSION"="0.1"]]))
in
    Source
in
    function
dkay84_PowerBI's avatar
dkay84_PowerBI
Microsoft Employee
9 years ago

Since you said you are new to PBI, do you know how to create a function in the query editor?

adam_cogswell's avatar
adam_cogswell
Regular Visitor
9 years ago

Not specifically for PBI, no. I have had plenty of experience in other platforms and tools with functions, however.