Excel Files Extraction from SharePoint & Lakehouse File Sharing Issues

Hi Felpan ,

Thanks for the update.

The warning “Unverified HTTPS request is being made to...” typically appears when SSL certificate verification is disabled using verify=False in a requests call. While this can help bypass certificate issues during testing, it is not a secure long-term solution.

If you're using this approach:

response = requests.get(url, headers=headers, verify=False)

Remove verify=False and ensure your system trusts the SSL certificate used by SharePoint or Graph API. You can also use the certifi package to include trusted CA bundles.

To temporarily suppress the warning during development:

import urllib3
urllib3.disable_warnings(urllib3.exceptions.InsecureRequestWarning)

or:

import requests
requests.packages.urllib3.disable_warnings()

Note: Suppressing HTTPS verification is not recommended for production environments. It's safer to ensure your system trusts the certificate or use a valid CA certificate bundle.

Since you're working with SharePoint files via Graph API in Fabric notebooks, suppressing the warning may help temporarily, but securing the connection should be considered as a next step if you plan to move this into production.

Hope this helps. Please reach out for further assistance.
Please consider marking the helpful reply as Accepted Solution to assist others with similar issues. A kudos would also be greatly appreciated.

Thank you.