Invoke Function Based on User Selection

[a68tbird]

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?

Thanks!

[v-yulgu-msft]

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