topic Re: Azure SA mounted but can't load files in Data Engineering

Azure SA mounted but can't load files

niels — Tue, 26 Jul 2022 08:38:49 GMT

I am attempting to load an excel file that's located in a blob storage that I've mounted. In the first cell, when I use the dbutils.fs.ls command, I can see the file I want to load. However, when I try to actually load it, it can't find the file.

It feels like a simple task, but I can't figure it out.

Any help would be greatly appreciated.

Re: Azure SA mounted but can't load files

-werners- — Tue, 26 Jul 2022 12:06:10 GMT

I see you use pandas.

make sure you use the pyspark.pandas.read_excel version, plain pandas reads from local files.

Re: Azure SA mounted but can't load files

Vidula — Mon, 05 Sep 2022 13:26:07 GMT

Hi @Niels Ota

Hope all is well! Just wanted to check in if you were able to resolve your issue and would you be happy to share the solution or mark an answer as best? Else please let us know if you need more help.

We'd love to hear from you.

Thanks!