Hi, I intend to retrieve table data with Run a query against a dataset connector. The problem is the output of the query is incomplete, only partial rows can be returned. I roughly have 70,000 rows and 11 fields, and only 2,3000 rows returned.
My flow is designed to query the data from a power bi dataset and then write into a csv file under a sharepoint folder. I firstly noticed the data is lost in csv file, so i backtracked to the previous processes and found the query result is not complete.
I am wondering if there is an approach to fix this. Thanks in advance!
