Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!!
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.