This doesn't seem to be supported. There is an alternative but requires using pyodbc and adding to your init script. Details can be found here:

https://datathirst.net/blog/2018/10/12/executing-sql-server-stored-procedures-on-databricks-pyspark

I have tested this myself and works fine. If anyone has any alternative methods please let me know.