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
shilpavish
Frequent Visitor

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 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.

1 REPLY 1
v-micsh-msft
Microsoft Employee
Microsoft Employee

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.