SQL stored procedures in DirectQuery mode

Hi there, I have read the comments on the relevant PBI forums about calling SQL stored procedures in DirectQuery mode, but it's not working for me. Could you please assist me validate the following ...