Forum Discussion

shilpavish's avatar
shilpavish
Frequent Visitor
8 years ago

Pass parameters dynamically from Power BI to Stored Procedure

Hi, I have a stored proc that takes a hotel name as a parameter to retrieve a whole set of measures required by my dashboard. I want to be able to allow the users to select a specific hotel from ...
Need Help
Tips and Tricks
v-micsh-msft's avatar
v-micsh-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

What is your data source, and how you connect to the actual data?

 

Have you checked the Query Parameter?

 

Instead, if you would like to pass the filter to the stored Procedure dynamically, then you may consider the following scenario:

1. Take use of Live connection, this only supports Analysis Service,

2. Add PowerApps custom Visual, make sure it has the proper connection configured with the slicer,

3. Add a Flow within the PowerApps custom Visual, and then pass the slected data through the Flow to the Stored Procedure.

 

Haven't test it yet, so it may not work as expected. Let me know if you encountered any issues.

 

Regards,

Michael