Forum Discussion

Bayernboy23's avatar
Bayernboy23
Frequent Visitor
2 years ago
Solved

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

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. 

 

2 Replies