Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-16-2022 02:38 AM
Hi,
How can I load an Excel File (located in Databricks Repo connected to Azure DevOps) into a dataframe? When I pass the full path into the load method, it displays an error.
java.io.FileNotFoundException Has someone done it previously?
Labels:
- Labels:
-
Azure
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-20-2022 06:10 AM
Please give us exact file and code , we will try to debug it , I have done this multiple time, please share more details
Thanks
Aviral Bhardwaj
AviralBhardwaj
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-20-2022 10:17 AM
Hi,
Just managed to do it.
- Upgraded the cluster to the latest version because Files in Repos only works in most recent versions of the cluster.
- When loading the dataframe, specify the path as follows: file:/Workspace/Repos/user@email.com/filepath/filename.xlsx
