u/Eastern_Sale3639

https://preview.redd.it/fe1yz91o4f2h1.png?width=800&format=png&auto=webp&s=fb4d699ae3cf49538b46033cc63e2b8aaf44fd95

Hi everyone,

I’m having an issue with the Azure Databricks Excel Add-in when trying to query a Unity Catalog table/view from Excel.

The user already has the following permissions:

• USE CATALOG on the catalog
• USE SCHEMA on the schema
• SELECT on the table/view
• BROWSE on the catalog
• CAN USE permission on the SQL Warehouse

However, when using the visual table selector / preview option in the Excel Add-in, Excel shows the following error:

Excel Operation Failed

Excel operation failed in TableSelector

{
  "ok": false,
  "status": 200,
  "statusText": "",
  "body": {
    "statement": "SELECT `SOC_ID` FROM `qa_gold`.`bix_cmr_ab_nacional`.`vtx_cmr_gestion_comercial` LIMIT 1000",
    "warehouseId": "73771902e1b3c9e5"
  }
}

The SQL statement shown in the error is:

SELECT `SOC_ID`
FROM `qa_gold`.`bix_cmr_ab_nacional`.`vtx_cmr_gestion_comercial`
LIMIT 1000;

I already confirmed that the SQL Warehouse permission is assigned, and the Unity Catalog privileges seem to be correct.

Has anyone seen this issue before with the Azure Databricks Excel Add-in?

I’m trying to understand whether this is:

1. A permissions issue still missing somewhere,
2. A problem with the Excel Add-in TableSelector / Preview feature,
3. A limitation or bug in the current Excel Add-in,
4. Or something related to the specific view/materialized view being queried.

Any suggestions on what else to validate would be appreciated.

Thanks!