Forum Discussion

sriramanat's avatar
sriramanat
Regular Visitor
9 months ago
Solved

Calling TVF with parameter from slicer

I am creating a Power BI desktop report. I am having a dropdown to display Employee details, displaying employee name (Got employee dataset with a data source). I taken another data source in the sa...
Need Help
  • V-yubandi-msft's avatar
    V-yubandi-msft
    9 months ago

    Hi sriramanat ,

    I know this feature can be a bit confusing at first. I can’t do a Teams call, but I’m happy to guide you through the steps as clearly as possible.

     

    This is the official Microsoft article that explains exactly how to pass a slicer value into a SQL query or TVF using Dynamic M Query Parameters: Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn.

    If you’re still having trouble after reviewing it, please share more details or a screenshot of your setup. That will help in resolving the issue.

     

    Regards,
    Yugandhar.

MasonMA's avatar
MasonMA
Icon for Super User rankSuper User
9 months ago

Hi

You can try first creating an M parameter in Power Query like 

 

EmployeeId = 1

 

and use that M parameter inside a query that calls your table valued function. 

 

let
Source = Sql.Database("ServerName", "DBName",
[Query = "SELECT * FROM dbo.GetDirectReports(" & Text.From(EmployeeId) & ")"])
in
Source

 

then use EmployeeID in the slicer field, this way when select an employee in the dropdown, Power BI would requery the TVF, passing that EmployeeID to the SQL function (only under DirectQuery, for Import you'd need to refresh).