WEB Source GET Request - Adding query after header

[Anonymous]

So I have this successful GET request built in a Power Automate Flow (see screenshot below)

I want to create this exact same GET request in Power BI which I have partially succeeded in using the WEB source:

What I am missing however is the "Offset" & "limit" queries which I need, as otherwise I only get shown 50 results from over 150.
How can I achieve this?

(Please note, I do not have a lot of experience with Curl commands or the like, so a easy to understand explanation would be amazing)

[v-yanjiang-msft · Accepted solution]

Hi @Anonymous ,

Please try to use query parameters in Power Query (M language). Here is an example, assuming the output is JSON, you would do it like this(you do it in the advanced editor):

let
  src=Web.Contents(baseUrl, [RelativePath = urlPath, Query=[#"api_token" = apiKey, limit=Text.From(limit), start=Text.From(offset)]])
  json = Json.Document(src)
in
  json

In the above examples, parameters are:

• baseUrl for root API path
• urlPath for API endpoint
• apiKey for API authorization token
• limi and offset for getting a subset of data

Best regards,

Community Support Team_yanjiang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.