OData Feed | Parameters Existing Table Column

[ColonelHawx1008]

Hi All, 

Noob here with little BI skills, but I have tried searching and watched numerous videos with no luck.

My request:

I have an existing OData Feed that connects to a specific URL, this imports a column named "id"

I would like to create approx. 350 additional OData Feed Queries using a URL https://api.securitycenter.microsoft.com/api/recommendations/ENTER-THE-ID-HERE/machineReferences

However, I want to automate this query by PULLING the ID and inserting it to the portion of the URL where is says "ENTER-THE-ID-HERE.

Let say the column named id has the following id : va-_-adobe

The URL by default is and will always remain the same, with just the "id" field being different (350 different IDs) 

So it will then become: 

https://api.securitycenter.microsoft.com/api/recommendations/va-_-adobe/machineReferences, I want to pull the id int

Any idea how on earth I can perform this?

Thanking you in advance!!

[v-yanjiang-msft]

Hi @ColonelHawx1008 ,

Please see if this solution can help: Power Query from dynamic URL - Microsoft Community Hub

Best Regards,
Community Support Team _ kalyj

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