'Run a query against a dataset' connectors cannot return all data

(0) Share

Report

Posted on by Haowei

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!

All responses (2)

Answers (1)

Haowei 4 on at

Like (0)

Report

Re: 'Run a query against a dataset' connectors cannot return all data

Thanks a lot!
Verified answer

lbendlin 7,943 Super User 2025 Season 1 on at

Like (0)

Report
Re: 'Run a query against a dataset' connectors cannot return all data

Unlocking new self-service BI scenarios with ExecuteQueries support in Power Automate | Microsoft Power BI Blog | Microsoft Power BI

Exporting data into csv files. This is a limited scenario because the ExecuteQueries REST API restricts query results to 100,000 rows or 1,000,000 values per query (whichever is encountered first) and the number of queries to 120 per minute. We have no plans to increase these limits. So, if you must export query results, keep the data quantities manageable.