Like @Ryan Daly said, you can do this "natively" using Databricks SQL (since SSRS and other tools can "see" the SQL endpoint can communicate with it via ODBC (using the Simba Spark driver). We have integrated this way with PowerBI, SSIS, SSRS, desk...
Agree with @Werner Stinckens . We built a lake pipeline to feed that data via the API into lake storage (so we could keep more query history and combine that history "across" workspaces.
This is nearly ALWAYS an Azure VM supply issue. We've seen in multiple times in the past 18-24 months. Ours (also in Azure East region) appear to all be fine at the moment. Do you know what region you're in/what VM series you're relying on? You likel...