cancel
Showing results for 
Search instead for 
Did you mean: 
Warehousing & Analytics
Engage in discussions on data warehousing, analytics, and BI solutions within the Databricks Community. Share insights, tips, and best practices for leveraging data for informed decision-making.
cancel
Showing results for 
Search instead for 
Did you mean: 

Databricks excel plugin error

oyslan
Visitor

Hi, i have an error with the excel pluging.

It was working fine until today. I can login and browse the catalog but I get an error when trying to query any data. It seems like its sending in a blank warehouse id. I have choosen a warehouse and its running. 

Anyone who knows what the reason can be?

Error message:
Excel operation failed in TableSelector: {"ok":false,"status":400,"statusText":"","json":{"error_code":"INVALID_PARAMETER_VALUE","message":"INVALID_PARAMETER_VALUE: is not a valid endpoint id."},"body":{},"statement":"SELECT `report_concept_id`, `code`, `name_no`, `name_en` FROM `tower-cs_dev_base`.`heartbeat`.`report_concept` LIMIT 1000","warehouseId":""}

 

1 REPLY 1

GaneshI
New Contributor II

It looks like the issue is coming from the Snowflake Excel connector not receiving a valid warehouse/endpoint identifier when executing the query.

Since login and catalog browsing work fine, authentication is OK — the failure happens at query execution time, which usually points to one of these causes:

  • The selected warehouse session context is not being passed correctly (blank/invalid warehouse ID)
  • The worksheet/excel plugin session lost the warehouse binding after an update or session timeout
  • The connector update changed how endpoint/warehouse IDs are resolved (this has happened in recent connector versions)

What you can try:

  • Re-select the warehouse in the Excel plugin and reconnect (don’t rely on the previously selected one)
  • Fully log out of the Excel plugin and log back in
  • Restart Excel to clear cached session metadata
  • Verify the warehouse is active and not suspended
  • If multiple accounts/regions are used, ensure you're connected to the correct Snowflake account endpoint

If it started suddenly today, it’s very likely a session/connector-side issue rather than a SQL problem.

If the issue persists, checking the latest Excel connector version or reinstalling it often resolves this type of “invalid endpoint id” error.