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

[pperumal]

Hi,

Is it possible to pass the slicer value from power BI as a parameter to a SQL stored procedure ?

Thanks in Advance!

[v-jingzhang · Accepted solution]

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!

[WillDrotar]

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.

[TomMartens]

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=...

Hopefully, this provides what you are looking for.

Regards,

Tom

[gzsedely]

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

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

[TomMartens]

Hey @gzsedely ,

I do not think that direct query is supporting calling stored procedures.

Regards,

Tom

[gzsedely]

Indeed, you are right!

[pperumal]

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.