In this post, We’ll focus on how to read a OData service with a parameter.
Now, we’ll see how to retrieve data with a parameter,
In browser, we can see only filtered students. in url, append the parameter with values.
From the Power Query window, we can see dataset like this.
I could create a github repo for this code sample, Please feel free to check it, https://github.com/hansamaligamage/ODATAExample