Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Run a query against a dataset doesn't show all data

Hello All,


I am using the 'Run a query against a dataset' connector, and last week I was able to get all 67,000 rows (10 columns) back using this connector, however when using it now this week I am only able to get 58,000 rows (roughly 10,000 less than before) no matter what I do. The connector obviously is able to bring the amount of rows I need back, but I am not able to figure out how to get it to work again. I have tried creating another flow similar to this, I have tested that the query and it shows that the number of rows is correct, it just doesn't seem to work when entered into power automate. 

Has anyone else experienced this and if so how did you fix it. I need all rows to come back at once and to my knowledge I am not hitting any limits. 


Please help! 


Emily Pollard

Frequent Visitor

I have the exact same issue in multiple flows, I have no idea what is causing this

Regular Visitor

Best I can tell is that there is some total data limit in the "Run a query against a dataset" call.  If I add more columns (more data), I get less rows.  I've been searching, but I haven't seen any documentation that speaks to the limit, whether it can be changed, etc.


I even looked at the raw JSON output of the query step, and its records were limited.  (That is, in my case, it wasn't the "Create CSV table" next step that was causing the limit.)

Frequent Visitor

Thanks.  I saw that work-around, and planned on using it if folks still want the larger dump.  Seemed a lot of hoops to jump through.

But thanks for the response!

Helpful resources

Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,435)