- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-16-2023 09:11 AM
I'm having an issue accessing the excel through dlt pipeline. the file is in ADLS I'm using pandas to read the Excel. It seems pandas are not able to understand abfss protocol is there any way to read Excel with pandas in dlt pipeline?
I'm getting this Error: "ValueError: Protocol not known: abfss"
- Labels:
-
Delta Live Pipeline
-
DLT Pipeline
-
Python
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-25-2023 03:13 AM
what if you use the pyspark.pandas.read_excel function? I think you use the 'normal' pandas variant, not the pyspark one.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-09-2023 12:16 AM
Thanks for the info. It works just need to install an additional library using "%pip install openpyxl".
