Power BI Snowflake connector

Hello,

Problem statement: We are trying to conncect Power Bi with a snowflake instance housed in AWS with built in connector (without gateway).

When looking at the query editor, we use SQL and custom parameter to limit request size:
Source = Value.NativeQuery(Snowflake.Databases("Server_name","Warehouse_name"){[Name="Table_name"]}[Data],
"SELECT * from Table_name#(lf)WHERE ""Customer"" = '"&Customer parameter&"'", null, [EnableFolding=false])

We want to know: It seems that when evaluating querry PBI sents multiple cloned requests to Snowflake which impacts the duration it takes to retrieve results.

If anyone has similar axperience, any help would be highly appreciated. 

Thanks!