Reply
DALI007
Helper II
Helper II

Data Factory : Configuration gateway

Gateway.png
Hello,
I am connecting to an Oracle database through a gateway using my DataFlow Gen 2 (see attached photo). I would like to know if it is possible to configure this gateway to automatically limit the number of rows retrieved from any table in the database when I connect through this gateway.
Thank tou for yoyr help

1 ACCEPTED SOLUTION
miguel
Community Admin
Community Admin

A connection fundamentally only has information about the data source and the credentials associated with it.

Information about how data should be retrieved is handled through the different applications and experiences.

 

The only way to limit the number of rows retrieved from a given data source, using a specific connection, is by using either a notebook, a data pipeline or a dataflow and implementing the specific filters or using specific views from the data source that have the limiting logic in place.

View solution in original post

1 REPLY 1
miguel
Community Admin
Community Admin

A connection fundamentally only has information about the data source and the credentials associated with it.

Information about how data should be retrieved is handled through the different applications and experiences.

 

The only way to limit the number of rows retrieved from a given data source, using a specific connection, is by using either a notebook, a data pipeline or a dataflow and implementing the specific filters or using specific views from the data source that have the limiting logic in place.

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebFBC_Carousel

Fabric Monthly Update - February 2025

Check out the February 2025 Fabric update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)