Fabric Notebook - Loading Data (API and On-prem DB) into Fabric Notebook through Python Modules

[Bayernboy23]

I am trying to use a Fabric Notebook to create Python code that pulls data from a internal API (Google Apigee) with data from a on-premises SQL Server database. I am able to run the code locally on my desktop via the requests and pymssql python modules, but I seem to run into issues when running the code on a Fabric notebook. There seems to be a disconnect when connecting to both the API and on-prem database. I have custom M code in Power Query that can pull the API and SQL databse both on my PBI desktop and in the cloud. The two connections have a gateway configured and are online in the service.  

Does anyone know if you need a gateway configured for this? If so, how can we configure a gateway and assign it to the Fabric notebook. 

[v-shex-msft · Accepted solution]

HI @Bayernboy23,

Perhaps you can take alooka t the following document about conjugation gateway for fabric product if helpes for your scenario:

How to access on-premises data sources in Data Factory - Microsoft Fabric | Microsoft Learn

Regards,

Xiaoxin Sheng