This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 2%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
Hi, when trying to read an excel file from ADLS Gen2 with synapse notebook and pandas i recieve the following error:
URLError : <urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:852)> Traceback (most recent call last): File "/home/trusted-service-user/cluster-env/env/lib/python3.6/site-packages/pandas/util/_decorators.py", line 208, in wrapper return func(*args, **kwargs) File "/home/trusted-service-user/cluster-env/env/lib/python3.6/site-packages/pandas/io/excel/_base.py", line 310, in read_excel io = ExcelFile(io, engine=engine) File "/home/trusted-service-user/cluster-env/env/lib/python3.6/site-packages/pandas/io/excel/_base.py", line 819, in init self._reader = self._enginesengine File "/home/trusted-service-user/cluster-env/env/lib/python3.6/site-packages/pandas/io/excel/_xlrd.py", line 21, in init super().init(filepath_or_buffer) File "/home/trusted-service-user/cluster-env/env/lib/python3.6/site-packages/pandas/io/excel/_base.py", line 348, in init filepath_or_buffer = BytesIO(urlopen(filepath_or_buffer).read()) File "/home/trusted-service-user/cluster-env/env/lib/python3.6/urllib/request.py", line 223, in urlopen return opener.open(url, data, timeout) File "/home/trusted-service-user/cluster-env/env/lib/python3.6/urllib/request.py", line 526, in open response = self._open(req, data) File "/home/trusted-service-user/cluster-env/env/lib/python3.6/urllib/request.py", line 544, in _open '_open', req) File "/home/trusted-service-user/cluster-env/env/lib/python3.6/urllib/request.py", line 504, in _call_chain result = func(*args) File "/home/trusted-service-user/cluster-env/env/lib/python3.6/urllib/request.py", line 1392, in https_open context=self._context, check_hostname=self._check_hostname) File "/home/trusted-service-user/cluster-env/env/lib/python3.6/urllib/request.py", line 1351, in do_open raise URLError(err) urllib.error.URLError: <urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:852)>
When running the same code locally from my machine, there's no issues. Code: import pandas as pd ReadExcel=pd.read_excel('https://datalake2devjohan.dfs.core.windows.net/testdata/Korttidsplatser.xlsx****?saskey****') print(ReadExcel) I've seen other examples where this is possible. Thank you.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 44%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
@holmaq Thanks for using Microsoft Q&A !!
Looks like a certificate issue in your environment but we are looking into this and get back to you.
@holmaq Following up as I haven't heard back. Can you please help providing the information to investigate it further ?
@holmaq Please let me know if you are still facing this issue and kindly share the requested information for further investigation.
@holmaq I am tracking this internally with the products team and need the requested information to investigate further. Please let me know if you are still having issues and need help on this one. Thanks
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 98%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFB%3C/text%3E%3C/svg%3E)
Hi all,
So you have any update on this? I´m facing the same issue.
Thanks in advance for your help
Regards
@Fernando Bloise I have not received any response from @holmaq over email with details from products team to investigate further.
Are you be able to provide this information over an email to azcommunity[at]microsoft[dot]com with this Q&A thread link and subject as "Attn: Saurabh' and I will help taking this forward with the products team.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 84%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHN%3C/text%3E%3C/svg%3E)
Any solutions to this :)? I am facing the same issue
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 22%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
I responded as requested. Sent an email with details to azcommunity[at]microsoft[dot]com
Can you please clarify if this was resolved? Facing the exact same issue.