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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
DeepaS
Regular Visitor

Dynamic Stored Procedure Call based on user input parameters

I want to be able to execute a stored procedure based on the input parameters selected by end user

  1.  DirectQuery Mode : I'm able to use dynamic M query parameters for SQL queries using   -  https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters
  2.  Import Mode : Also, I'm able to execute a stored Procedure  but cannot pass end user input parameters here

 

If we have to create a table , it is going to generate several million rows. Hence, we want to dynamically get user input and fetch only a subset of this. Please suggest.

 

Thanks for your help in advance! 

1 ACCEPTED SOLUTION
Daryl-Lynch-Bzy
Resident Rockstar
Resident Rockstar
3 REPLIES 3
DeepaS
Regular Visitor

@Daryl-Lynch-Bzy 

 

We are having function1 to feed data for Page1 and function2 to feed data for Page2. When we drill through from Page1 to Page2, the transient filters are displaying correct values but the data is not filtered in Page2 based on Page1 filters ( transient filters). Please suggest.

 

Thanks,
Deepa

DeepaS
Regular Visitor

Hello Daryl,

Thank you very much for your response. The Function worked for us. Appreciate your time 🙂

We used this site as suggested by you.

Chris Webb's BI Blog: TSQL Table-Valued Functions And Dynamic M Parameters In Power BI DirectQuery C...

 

Daryl-Lynch-Bzy
Resident Rockstar
Resident Rockstar

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors