Forum Discussion
Krish89
Helper II
Helper IIHow to pass parameter values to the url in Power query
Hello, I am trying to fetch the list of datasources used in all the datasets at tenant level using the below api endpoint. https://api.powerbi.com/v1.0/myorg/admin/datasets/{datasetId}/datasourc...
mahoneypat
Microsoft Employee
Microsoft EmployeeYou can make a table that has a column of all your dataset IDs and then add a custom column (or invoke a custom function) with your Source expression that concatenates that ID value as text into the larger expression
Web.Contents("... part of URL/" & [ColumnWithDatasetID] & "/rest of url...")
Pat