Forum Discussion
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!
Hi pperumal
You may try the method introduced in this blog: Chris Webb's BI Blog: TSQL Table-Valued Functions And Dynamic M Parameters In Power BI DirectQuery
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!
This could also be the input parameter of the stored procedure!
For example, in the SQL script of the SQL server connector!
Hey gzsedely ,
I do not think that direct query is supporting calling stored procedures.
Regards,
Tom
Indeed, you are right!