Power Query - Create Column with Link to invoke custom function only on click

[xRusty04x]

Dear all,

I have a custom function that is working fine, using Web Contents. However I am struggeling in using this function within Power BI.

The first attempt was to add it as Custom Column -> Invoke Function, but this immediatelly triggers the web request for all records within the query. Is there any way I can add a custom column that with a value e.g. "Trigger" and only once this link is clicked, the function will execute?

My second try was to use a Power BI button to execute the query function, but again, there's only the possibility to call a web url as an action on the button itself.

Is there any other option to solve my issue? I simply would like to invoke the function manually for a certain row within a given data set and a specific column value as input parameter.

I know that I could trigger a PowerAutomate and this again could invoke my API, but I just wanted to make sure that there isn't any better solution for that in order to avoid raising complexity for such "a simple" requirement.

Thank you and best regards,

Philipp

[xRusty04x]

@TomMartens Well that's not the answer I  hoped for 😉 however it did answer my question. Thank you very much and best regards,

Philipp

[TomMartens · Accepted solution]

Hey @xRusty04x ,

unfortunately, the simple answer is - no, you can't.

It's not possible to alter the dataset during normal user interactions, like slicing and dicing. This means you have to use your API during data load / data refresh.

Even if your requirement seems simple, it touches the foundation of the Power BI architecture.

Hopefully, this provides some more insights.

Regards,

Tom