Administration & observability · Reliability and controls

Which BI tools let admins switch AI on or off?

11 of 15 tools do, according to their public docs, and 3 partly.

Yes: Databricks, Snowflake, Omni, Sigma, BigQuery, Looker, Tableau, Power BI, Metabase, Alteryx, Redshift. Partly: Hex, MotherDuck, Mode.

The question we asked: Can an administrator enable or disable AI features for particular users, groups or workspaces?

Prompt your agent about thisClaudeChatGPT
Grading standard

A documented control that turns AI features on or off for a subset of the tenant. An account-wide on/off with no granularity is partly; a setting that only governs which model is used is MODELPIN, not this.

Databricks

Yes
Quoted from Databricks’s docsYou can manage this setting at the account or workspace level, subject to the removal timeline described above.
Source: docs.databricks.com/aws/en/databricks-ai/partner-powered · checked Oct 26, 2026 · quoted by GPT
Claude partly · GPT yes · Gemini yes

Snowflake

Yes
Quoted from Snowflake’s docsYou can grant these roles to specific roles that you want to have access to the features, then grant those roles to specific users as needed.
Source: docs.snowflake.com/en/user-guide/snowflake-cortex/opting-out · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

Omni

Yes
Quoted from Omni’s docsAdded granular model role permissions for AI access. Administrators can now control AI feature access and workbook access at the model role level, providing more fine-grained permission management.
Source: docs.omni.co/changelog/2025 · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini partly

Hex

Partly
Quoted from Hex’s docsBy disabling this setting you will disable all AI features in your workspace.
Source: learn.hex.tech/docs/administration/workspace_settings/enable-ai-and-agents · checked Oct 26, 2026 · quoted by Claude
Claude partly · GPT partly · Gemini yes

Sigma

Yes
Quoted from Sigma’s docsControl who can access different AI features by enabling feature permissions on different account types assigned to users:
Source: help.sigmacomputing.com/docs/configure-ai-features-for-your-organization · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

BigQuery

Yes
Quoted from BigQuery’s docsTo prevent a user from using Gemini in BigQuery features, revoke the specific cloudaicompanion IAM permissions that grant access to these capabilities, as detailed in Enable necessary APIs and grant roles.
Source: docs.cloud.google.com/bigquery/docs/gemini-set-up · checked Oct 26, 2026 · quoted by GPT
Claude yes · GPT yes · Gemini yes

Looker

Yes
Quoted from Looker’s docsTo restrict users from accessing Gemini in Looker features for all models on the Looker instance, you can create a custom Looker role that applies the gemini_in_looker permission for specific models only, and assign it to the appropriate users or groups.
Source: cloud.google.com/looker/docs/admin-panel-platform-gil · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

Tableau

Yes
Quoted from Tableau’s docsYou can turn on AI in Tableau features for either a single user group or for all users on your site.
Source: help.tableau.com/current/online/en-us/setup_tabAI_site_setting.htm · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

Power BI

Yes
Quoted from Power BI’s docsIf you enable Copilot in Fabric in your capacity for a user or security group, then all workloads and Copilot experiences are accessible for those users.
Source: learn.microsoft.com/en-us/power-bi/create-reports/copilot-semantic-models · checked Oct 26, 2026 · quoted by GPT
Claude yes · GPT yes · Gemini yes

Metabase

Yes
Quoted from Metabase’s docsThe AI feature access table lets you toggle Metabot on or off per group, and pick what Metabot can do for each group.
Source: www.metabase.com/docs/latest/ai/usage-controls · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

Alteryx

Yes
Quoted from Alteryx’s docs- To allow access to Agent Studio but not Alteryx Agents, Workspace Admins can assign users a custom role with Agent Studio enabled and AI Agents disabled. This allows users to manage external MCP connections and set up assets without access to Alteryx Agents.
Source: help.alteryx.com/aac/en/agent-studio.html · checked Oct 26, 2026 · quoted by GPT
Claude yes · GPT yes · Gemini yes

MotherDuck

Partly
Quoted from MotherDuck’s docsOrganization Admins can turn Agent chat on or off on the AI Features page in Settings.
Source: motherduck.com/docs/key-tasks/ai-and-motherduck/agent-chat · checked Oct 26, 2026 · quoted by Claude
Claude partly · GPT partly · Gemini partly

Mode

Partly
Quoted from Mode’s docsTo ensure that we provide the best possible experience for our users, we are turning AI Assist on an account-by-account basis, by request only.
Source: mode.com/help/articles/ai-assist · checked Oct 26, 2026 · quoted by Claude
Claude partly · GPT partly · Gemini partly

Redshift

Yes
Quoted from Redshift’s docsTo use Amazon Q generative SQL, you need permission sqlworkbench:GetQSqlRecommendations in your IAM policy, in addition to other permissions specified in the AWS managed policy for query editor v2.
Source: docs.aws.amazon.com/redshift/latest/mgmt/query-editor-v2-generative-ai.html · checked Oct 26, 2026 · quoted by Claude
Claude yes · GPT yes · Gemini yes

Streamlit

Not found
Nothing in the docs settles this.
Claude nothing found · GPT nothing found · Gemini nothing found