Forum Discussion

sachti's avatar
sachti
Frequent Visitor
9 years ago

Power SQL access to filter selection

Hallo,   short: How can i get access to the filter in a parameter definition (Power SQL)?   long: I have a dashboard with a filter. When i select an item, I want to use the selected value in a...
Need Help
sachti's avatar
sachti
Frequent Visitor
9 years ago

Hallo v-yulgu-msft,

 

thank you for your help. The parameter usage is the part already working.

 

= (Rid as text, Id as number) =>
let
    Source= Sql.Database("DATABASENAME", "DATABASENAME2", [Query="EXEC SqlStoredProcedureTable #(lf)@Rid = '" & Rid & "' ,#(lf) @Id  =  " & Number.ToText(Id) & ";"]
in
    Source

 

this is running.

 

The followig Picture describes it better. I want to select a jobrid and with this the stored procedure can return the measurement data for displaying in a graph.

 

 

Thats why i try to get the selected value as parameter for the stored procedure.

But here i use the slicer as drop down menue.

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

Hi sachti,

 

As I mentioned in my original post, it is not possible to pass the selected value from slicer to stored procedure. As the available values displayed in a slicer must be fetched and returned by dataset first (in your scenario, use a stored procedure). The logic that using a slicer to filter dataset does not make sense.

 

Best regards,
Yuliana Gu