Showing results for 
Search instead for 
Did you mean: 
Resolver II
Resolver II

Invoke Function Based on User Selection

Hello All -

   Here's my situation.  I have an orders table with customer email, order number and a shipping reference number. I also have a custom function that will make an API call using that shipping reference number and return a tracking link.  These API calls have to be on demand - I can't load a table of 10,000+ records and expect to get responses.  That many calls at once will just be frowned upon. 


What I ideally would like is to have a table of order details on the user canvas with a slicer on email address.  When a user searches for the customer email address, the order details table filters to the order in question, and then upon selection (highlight or something) triggers the custom function to make the API call.  Note that the customer email can return multiple orders and multiple shipping references. 


Is this possible? Any one have any suggestions on a different way to approach?





Hi @a68tbird,


No. It is not possible to pass a slicer selection to Power Query and invoke the custom function. Please be aware that Power BI always gets dataset first via Power Query, then, we can display the data in report page. We cannot pass any value from report to Power Query.


Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors