Dynamic Parameter binding to a drop down filter to pass to a stored procedure or view in DIRECT mode

[sasdfasdfsad]

I want to setup a PBI report where we can run a stored procedure against our data warehouse to return ALL the customer's order history.

This is TOO LARGE to do as an IMPORT so I want to use a stored procedure to call it in Direct Query mode.  This works fine.

The problem is this:
How can I create a filter/slicer in the PBI report that loads a list of all customer's and lets the user search the customer list then select one and pass that selected customer to the stored procedure?

I can do this with two reports, where they load the "select customer" report first then it passes it as a cross-report filter.

However, I can not find a way to do this inside the same report.

I want the first page to use an IMPORT storage option to get a list of all customers and populate the filter.

Then the user searches and finds the customer and passes their CustomerID (right click drill through -> Details) to the stored procedure and it will execute.

I can't figure out how to bind the parameter to the value that the end user selects from the filter.

[v-ssriganesh]

Hi @sasdfasdfsad,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[v-ssriganesh]

Hello @sasdfasdfsad,

Could you please confirm if your query have been resolved? If they have, kindly mark the helpful response and accept it as the solution. This will assist other community members in resolving similar issues more efficiently.

Thank you.

[v-ssriganesh]

Hi @sasdfasdfsad,

May I ask if you have resolved this issue? If so, please mark it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[parry2k · Accepted solution]

I don't think that is a requirement. 

[parry2k]

@sasdfasdfsad I think you are looking for dynamic M query parameters; learn more about it here. 

[sasdfasdfsad]

I was looking at that and I thought it was the solution I needed, but when I saw it was talking about creating a table of values, it seems like you have to preopulate the table with static values or you can't populate it with like a list of customer names or emails that come from an SQL query?