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
What is your current authentication method to retrieve the files? Do you use user authentication? The best practise is to use a service principal to authenticate, so you are not dependend on the user trying to run the notebook. Especially is production. This link provides the steps to authenticate to OneLake using a service principal. It may solve your problem too.
https://debruyn.dev/2023/how-to-use-service-principal-authentication-to-access-microsoft-fabrics-onelake/