Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 am barking up the wrong tree.
What I did was to use the Web connector in Power BI. I set the connection up as follows (fake website but shows what I did):
The resultant code is shown below:
let
Source = Json.Document(Web.Contents("https://io.website.com/v1/account", [Headers=[#"X-API-Token"="MYTOKENDETAILS", #"X-Integration-ID"="rre5b7rg-a0ss-4cfd-8311-1e84d0d23359", #"Content-Type"="application/json", Accept="application/json", Method="Get"]])),
#"Converted to Table" = Record.ToTable(Source)
in
#"Converted to Table"
However, what I get back is just 1 piece of code:
The instructions from the client were:
I have spent quite some time looking around for how to extract this data and watched videos on using PowerShell (which is a whole new subject on its own). I am worried I am going down a rabbit hole and would appreciate if anyone can point me in the right direction!
Thanks for any suggestions.
Solved! Go to Solution.
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.
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
88 | |
85 | |
68 | |
66 | |
64 |
User | Count |
---|---|
208 | |
120 | |
113 | |
79 | |
72 |