Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Using API to extract data into Power BI

Hi there,    I am working on a project for a client to develop some Power BI reports based on their data using an API connection. Having never used an API connection, I need some help as I fear I a...
Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago

    You can stay within Power Query and make subsequent Web.Contents calls. You can use List.Generate(), List.Accumulate(), recursive functions, or data from your initial call to set up the looping.  In your case you may not even need loops, only data from the original request to formulate the second.

     

    By the way,  Method ="GET" is not a functionality of Web.Contents. You change methods via the payload.

     

    Web.Contents - PowerQuery M | Microsoft Docs

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

You can stay within Power Query and make subsequent Web.Contents calls. You can use List.Generate(), List.Accumulate(), recursive functions, or data from your initial call to set up the looping.  In your case you may not even need loops, only data from the original request to formulate the second.

 

By the way,  Method ="GET" is not a functionality of Web.Contents. You change methods via the payload.

 

Web.Contents - PowerQuery M | Microsoft Docs