Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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 November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors