cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Emily_Pollard
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

1 REPLY 1
lkkkhgg
Regular Visitor

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

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (3,124)