I know we've been able to successfully connect Power BI Service to Databricks via the Simba Spark ODBC driver installed on a PBI Gateway server. I haven't gone into trying through our SSRS server yet. I suspect it is likely possible if network and drivers are configured correctly.