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

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

Bayernboy23 — Wed, 24 Apr 2024 15:59:11 GMT

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.

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

Anonymous — Thu, 25 Apr 2024 03:09:04 GMT

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

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

NEJO — Fri, 25 Oct 2024 21:54:25 GMT

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