...
You need to first configure a connection setting that allows you to see the option to Enable raw data querying when designing cubessemantic models.
You can configure a connection to support Databricks SQL Warehouse, Presto, Spark, or HIVE for SQL raw querying.
You can also configure a Snowflake connection to support raw data.
You can switch from one connection type to another by disabling the Is Default SQL Engine option in the currently used connection before you can enable it in the connection type you want to use.
...