Using Power BI Spark SQL connector when quickly doing slice and dice on dashboard, queries are failing at database with orphan queries.

When executing queries in Power BI using the SQL connector, we encounter a problem where switching filters during a query execution does not cancel the queries promptly. They keep running on Datasource in the background. After some time, these queries fail and show errors that mention "orphaned queries."

This problem happens not just with Kyvos as Datasource but with Snowflake as Datasource when using the Spark connector.