Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Bayernboy23
Regular Visitor

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. 

 

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

1 REPLY 1
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Kudoed Authors