https://community.fabric.microsoft.com/t5/Dataflow/Data-Factory-Configuration-gateway/m-p/3730824#M2217 <P>A connection fundamentally only has information about the data source and the credentials associated with it.</P> <P>Information about how data should be retrieved is handled through the different applications and experiences.</P> <P>&nbsp;</P> <P>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.</P> Wed, 28 Feb 2024 14:10:32 GMT miguel 2024-02-28T14:10:32Z https://community.fabric.microsoft.com/t5/Dataflow/Data-Factory-Configuration-gateway/m-p/3730128#M2215 <P><img /><BR />Hello,<BR /><SPAN>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.<BR /></SPAN>Thank tou for yoyr help</P> Wed, 28 Feb 2024 09:22:21 GMT https://community.fabric.microsoft.com/t5/Dataflow/Data-Factory-Configuration-gateway/m-p/3730128#M2215 DALI007 2024-02-28T09:22:21Z https://community.fabric.microsoft.com/t5/Dataflow/Data-Factory-Configuration-gateway/m-p/3730824#M2217 <P>A connection fundamentally only has information about the data source and the credentials associated with it.</P> <P>Information about how data should be retrieved is handled through the different applications and experiences.</P> <P>&nbsp;</P> <P>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.</P> Wed, 28 Feb 2024 14:10:32 GMT https://community.fabric.microsoft.com/t5/Dataflow/Data-Factory-Configuration-gateway/m-p/3730824#M2217 miguel 2024-02-28T14:10:32Z