Forum Discussion
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!
7 Replies
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
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!Note the article says "You can only hard-code the values you pass to the function’s parameters at this point...."
That might be useful for parameter values like days of the week or months, but if you're using a slicer for date ranges, names, or anything dynamic this solution isn't really practical.
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!
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.
