Forum Discussion

pperumal's avatar
pperumal
Frequent Visitor
3 years ago
Solved

Pass slicer filter to the SQL Server DB - Direct Query Mode

Hi,   Is it possible to pass the slicer value from power BI as a parameter to a SQL stored procedure ?   Thanks in Advance!
General Comment
Need Help
Tips and Tricks
Tutorial Requests
gzsedely's avatar
gzsedely
Frequent Visitor
3 years ago

This could also be the input parameter of the stored procedure!

For example, in the SQL script of the SQL server connector!

pperumal's avatar
pperumal
Frequent Visitor
3 years ago

How do i pass the slicer filters as a input parameter to the stored procedure in the Direct Query. Could you please share any blog or notes available.