Dynamically control the Rest API URL for datasource "from Web" based on user input/interaction

Hi Panto 

You can create a Parameter from the Manage Parameters icon in the PQ menu.

This will allow you to specify a parameter/value that can be added to the URL.  As this parameter value is changed so the data returned by your Web request changes.

Here's a sample PBIX file demonstrating the procedure below.

For example click on Manage Parameters and then New Parameter

Fill in the details for the new parameter

After you click OK you will have a new parameter called StudentID listed under the queries on the left of the screen and you should see this

Now open your main query in the Advanced Editor, the source step should look something like this

Source = Web.BrowserContents("https://www.api.com/employee/")

Change it so it looks like this

Source = Web.BrowserContents("https://www.api.com/employee/"&Text.From(StudentID)),

Close the query and then click on the StudentID parameter query.

Change the value of the parameter, then click back on the main query.  It should load the data associated with the Student ID you just entered as the parameter value.

Regards

Phil

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.