Passing Parameters to a Stored Procedure or table function in DirectQuery mode

Hi,   I've found that it is possible to call a stored procedure (using OPENROWSET) pass in parameters when using DirectQuery mode.   However, this is only possible in PowerBI Desktop. Once the pb...