- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Data Factory : Configuration gateway
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Fabric Monthly Update - February 2025
Check out the February 2025 Fabric update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
05-28-2023 11:06 AM | |||
10-21-2024 02:54 PM | |||
12-18-2024 10:42 PM | |||
02-09-2025 04:07 PM | |||
01-08-2025 11:04 PM |
User | Count |
---|---|
6 | |
5 | |
2 | |
2 | |
2 |