Get the values from Card and pass it to SP

[PrakashM]

Hi All,

I want to get the value from the card visualization and pass it to Sql Stored procedure as a parameter. Whenever i am applying any filters in slicer then the card value will change . Based on the card value it will pass it as input for stored procedure.

Please advise on the same to achieve this.

Thanks!

[Eric_Zhang]

---

@PrakashM wrote:

Hi All,

I want to get the value from the card visualization and pass it to Sql Stored procedure as a parameter. Whenever i am applying any filters in slicer then the card value will change . Based on the card value it will pass it as input for stored procedure.

Please advise on the same to achieve this.

Thanks!

---

1. You can get the value of the card by using the same measure in the same context.
2. A stored procedure can be used in Import Mode, while in DirectQuery mode it is not supported, you would encounter some syntax error.
3. AFAIK, there's no way to pass a value in visuals to the Power Query where Power BI accesses SQL Server.

Can you be more specific on your scenario so that we can think of any other workaround.