Pass parameters dynamically from Power BI to Stored Procedure

[shilpavish]

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 a drop down/slicer and pass that hotel name to my stored proc and refresh the dashboard for the selection made.
I cannot load all the data first and then allow user to select the hotel name since the fact tables are extremely huge and would impact performance. Is there any way to dynamically pass the values to the Stored procedure as a parameter(at run time)?

If there is no solution to above, any workaround/ideas would greatly assist.

[v-micsh-msft]

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