cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Lakeflow Spark Declarative Pipelines do not support read_files with format excel yet

DhivyaKeerthana
New Contributor III

Error: Failed to find the data source: excel. Make sure the provider name is correct and the package is properly registered and compatible with your Spark version.

Upon checking the cluster details, it is running with 16.4 yet. When will it be updated to 17 or above?

1 ACCEPTED SOLUTION

Accepted Solutions

szymon_dybczak
Esteemed Contributor III

Hi @DhivyaKeerthana ,

As you correctly mentioned the native Excel support is available as a preview feature in runtime >= 17.
So you can try to use preview channel in SDP which is based on runtime version 17.3

szymon_dybczak_0-1769851247937.png

 

View solution in original post

3 REPLIES 3

szymon_dybczak
Esteemed Contributor III

Hi @DhivyaKeerthana ,

As you correctly mentioned the native Excel support is available as a preview feature in runtime >= 17.
So you can try to use preview channel in SDP which is based on runtime version 17.3

szymon_dybczak_0-1769851247937.png

 

DhivyaKeerthana
New Contributor III

Thank you @szymon_dybczak, it works!!

Great news @DhivyaKeerthana. I'm glad that it worked for you ๐Ÿ™‚