Forum Discussion
Error while reading XLSX file into dataframe using pandas
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/
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