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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
DALI007
Helper I
Helper I

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.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

March 2024 FBC Gallery Image

Fabric Monthly Update - March 2024

Check out the March 2024 Fabric update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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