Setting Up Gateway for Dynamic API Source that use a Function

[langer83]

Does anyone know how I could setup a datasource in a gateway that uses a dynamic API source?

I currently have a function in the desktop version that uses a table column to supply the parameters to an API source.

Function:

Source = Json.Document(Web.Contents("https://test.net/rest/api/2/issue/"& IssueParam &"/changelog?maxResults=1000"))

Issue Table:

A calculated column ( Function([IssueID]) ) uses the IssueID column to bring in values using the API function.

[v-qiuyu-msft]

Hi @langer83,

Thanks for sharing this idea. Vote it up as well.

Best Regards,
Qiuyun Yu

[langer83 · Accepted solution]

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/16537573-power-query-functions-in...

This functionality is currently not available. Please follow the link above and vote in hope that Microsoft makes this functionality available soon. 🙂