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!
Hey pperumal , the feature you are looking for is called dynamic M query parameters for direct query: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters?WT.mc_id=DP-MVP-5003068
Hopefully, this provides what you are looking for.
Regards,
Tom