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. 

[NEJO]

We have similar issues trying to connect Fabric notebook to on premise APIs, Odata, etc.  The notebook doesn't support the on premise gateway, and am finding that the Dataflow gen2 option is much slower than I would have liked.

You can vote the idea here though.

Microsoft Idea 

[Anonymous · 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