Forum Discussion
Solved
Error while reading XLSX file into dataframe using pandas
Hi, I have an Excel file (XLSX) in my lakehouse I'm trying to read this file into a pandas dataframe. I need to use the abfss path as the lakehouse is not the default one mapping_file_path = 'abfs...
No it didn't help. I have changed my source file type to json now and after that I am not facing any Unauthorization issue
Yes it's the default authentication. But why only with xlsx type of file this issue is occuring? Same time if I check for json or csv file there is no issue in loading the files. Any idea?
Is it possible that this file is modified at the same time you are trying to read it?
I can confirm that the xlsx file is at closed state when issue takes place. That's not the case it seems