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

(1) Share

Report

Posted on by MS.Ragavendar

7,431 Super User 2026 Season 1

I am using the 'Run a query against a dataset' connector, and last week I was able to retrieve few records but i want to retrieve all the data from the data model.

Can anyone provide some ideas.

I already checked this video but its not working - https://youtu.be/fbeMw9jtJB4

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

David_MA 14,956 Super User 2026 Season 1 on at

Like
a
(3)

Report
Copy link

Link copied!

I have never used the action and don't have time to watch a 23-minute video. But my guess is that you need to go into the settings of the action and enable paging. Most actions in Power Automate that retrieve data have default limits of how much data they return. You can override the default settings by enabling paging.

Was this reply helpful? Yes No
ScottShearer 25,290 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Can you tell me how many records are in the model and how many were returned?

Also, how long did it take to return those records?

Have you tested you query in Power BI or DAX Studio to verify that it works as you have intended?

Do you have a premium license for Power BI? If not, you are limited to 5000 loops max. The video mentions loops much larger than 5K.

Was this reply helpful? Yes No
Heather_itD Community Manager on at

Like
a
(0)

Report
Copy link

Link copied!

@MS.Ragavendar - did one of the responses from @ScottShearer or @David_MA help you or can you provide more information?

Was this reply helpful? Yes No