Power BI - Direct Query Execute SQL Server Stored Procedure with Parameters

[Anonymous]

Hello

I am trying to create a Power BI that connects to an SQL Server Stored procedure and the stored procedure has parameters, however, i need to do it using direct query. I have been unable to get it to work with direct query, it only seems to work with import, which is not possible for my application. 

Is this possible in any way to do this? i have tried many ways, but I have not had any success. 

I am using latest power bi desktop to create the power bi.

again, I need to do this with Direct Query, not import. 

[amitchandak]

@Anonymous , I doubt you can do that in case of a direct query