HTTP variable query params

[LangeJan]

Hello everyone

I am creating a Power BI report with data from http requests e.g.

https://api.openaq.org/v1/cities 

From my report I would like to be able to control Query Params so I e.g. can choose city.

https://api.openaq.org/v1/cities?city=007 

I can set the parameter city=007 in M ​​query but I have not been able to do this param variable.

M query:

let  

   cities_url = "https://api.openaq.org/v1/cities", //Web Url

   request_limit = "10000", //number represented by a string

   request_city = "007",

   Source = Json.Document(Web.Contents(cities_url, [Query = [city = request_city,limit = request_limit]])),

    results = Source[results],

    results1 = results{0}

in

    results1

Is it possible to make a report with variable query params?

Let me know if any further information is necessary

Thanks

[v-luwang-msft · Accepted solution]

Hi @LangeJan ，

Yes，you could create query parameter to change the city_id dynamically. You can refer the following documentations to achieve it.

Change the Source of Power BI Datasets Dynamically Using Power Query Parameters

Dynamic Web.Contents() and Power BI Refresh Errors

Web.Contents with dynamic file URL

Wish  it is helpful for you!

Best Regard

Lucien Wang

[LangeJan]

@mahoneypat 
Thanks for your reply.

it's a great video that gives good inspiration to move on. 

I can see from the video that I can control the parameters by predefining variables in a column and including these in the Http call.
I want the user of the report to be able to enter a keyword as a parameter in the report and get the result in the report with this parameter. Do you think that is possible?

[mahoneypat]

Yes.  You can concatenate parameters and/or column values into your web calls.  Please see if this video helps.

Power BI - Tales From The Front - REST APIs - YouTube

Pat