I tried the following installations to make sure SSL certificates are:
pip install -U openai
pip install pip-system-certs
pip install --upgrade certifi
Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us at FabCon Vienna from September 15-18, 2025, for the ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM. Get registered
I am using an Azure OpenAI model with Python notebook in Fabric.
client = openai.AzureOpenAI(
api_key=AZURE_OPENAI_API_KEY,
azure_endpoint=AZURE_OPENAI_ENDPOINT,
api_version=API_VERSION
)
response = client.chat.completions.create()
The above code when run throws SSL issue, although if I try it in local environment it works fine.
The error that appears is:
I tried the following installations to make sure SSL certificates are:
pip install -U openai
pip install pip-system-certs
pip install --upgrade certifi
Solved! Go to Solution.
Hello @govindarajan_d
give it a try
import httpx
client = openai.AzureOpenAI(
api_key=AZURE_OPENAI_API_KEY,
azure_endpoint=AZURE_OPENAI_ENDPOINT,
api_version=API_VERSION,
http_client=httpx.Client(verify="/path/to/your/custom_certificate.pem")
)
not recommended for prod, but lets see if this works
Also works with
Hello @govindarajan_d
give it a try
import httpx
client = openai.AzureOpenAI(
api_key=AZURE_OPENAI_API_KEY,
azure_endpoint=AZURE_OPENAI_ENDPOINT,
api_version=API_VERSION,
http_client=httpx.Client(verify="/path/to/your/custom_certificate.pem")
)
not recommended for prod, but lets see if this works
Hi @nilendraFabric,
The code worked, I pointed it to the existing certificate.
client = openai.AzureOpenAI(
api_key=AZURE_OPENAI_API_KEY,
azure_endpoint=AZURE_OPENAI_ENDPOINT,
api_version=API_VERSION,
http_client=httpx.Client(verify="/etc/ssl/certs/ca-certificates.crt"),
)
But why doesn't it work normally when other libraries like requests work without issues? Also, for production what would you suggest?
Great it worked @govindarajan_d
I would suggest store pem in Key vault and then use it here.
or store it in a place where it cant be accessed unauthorised.
it often contains sensitive information such as private keys, which must be protected from unauthorized access.
if this is helpful please accept the solution
@nilendraFabric We are not using custom key for certificate signing. Actually the above certificate is something that comes default with the spark environment (linux). I just pointed the http client to that certificate.
I am just wondering why it doesn't cause issue with requests library when I am hitting HTTPS sites. Strange though!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Fabric update to learn about new features.
User | Count |
---|---|
6 | |
4 | |
4 | |
3 | |
3 |