Forum Discussion
LangeJan
5 years agoHelper I
HTTP variable query params
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. ca...
- 5 years ago
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
mahoneypat
5 years agoMicrosoft Employee
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