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
Hi v-saisrao-msft
I am following https://www.youtube.com/watch?v=sjCDtDHej90&t=144s which shows how to read excel file from lakehouse
Normally reading the file from lakehouse :
pd.read_excel(mapping_file_path, header=0, sheet_name=0, dtype=str)
Regarding below points, how do I do that? Can you share any example for below please:
Regarding below points, how do I do that? Can you share any example for below please:
- Please ensure that the authentication token has a sufficiently long expiration time and is set to refresh automatically if required. If you are using the DefaultAzureCredential or a custom authentication mechanism, confirm the token's expiry and refresh it proactively.
- Please verify your configuration settings to confirm they are correctly set up for authentication.
Hi Arundhati_Sen1,
We haven’t heard back from you regarding your issue. If it has been resolved, please mark the helpful response as the solution and give a ‘Kudos’ to assist others. If you still need support, let us know.
Thank you.