Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
a68tbird
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?

 

Thanks!

 

1 REPLY 1
v-yulgu-msft
Employee
Employee

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

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.