Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi I am struggling with a query where I am passing some10 parameters in to a SQL Stored Procedure and trying to invoke the function to bring back result set. I created parameters and binded them to individual fields on Desktop from which the passed through into SQL Stored Procedure.
Whenever I try and invoke the result set is being created as a new table but I want only one query to get me the result set from stored procedure. Also I need help with figuring out how to get a button to execute the invoke function with the selections made on Desktop slicers.
Appreciate your help and thanks in advance
@angeleyes_7181 , I think you can do for SQL server, check
Hi @amitchandak Thanks for your reply. I have already done what you suggested in the link. Everything works fine till that point where I invoke the query and get a result set.
The next part I have done is to bind these parameters with individual fields so that the input is taken from these fields. I also have a parameter where its free text - basically the parameter should take input from a text box and pass it through stored procedure. Also when users make changes to selections then these should pass through sql sp and get me the result set. This is where I am stuck. Hope that's clear
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
90 | |
82 | |
62 | |
61 | |
58 |
User | Count |
---|---|
159 | |
114 | |
100 | |
75 | |
65 |