Limiting the # of rows to load from a table

[Jeff2Jets]

I am creating a Report in Power BI for a table that has 100,000+ rows. I don't need all of the rows to verify my Report is correct. Is there a way to only use the first 100-1000 rows from a table?

[v-pagayam-msft]

Hi @Jeff2Jets ,
Has the issue been resolved on your end? If so, please share your solution and mark it as "Accept as Solution." This will assist others in the community who are dealing with similar problems and help them find a solution more quickly.
Thank you.

[v-pagayam-msft · Accepted solution]

Hi @Jeff2Jets ,

Great suggestion @johnt75 !

As Johnt75 suggested, using “Keep Top Rows” in Power Query is a quick and effective way to limit your dataset. It helps improve performance and lets you test visuals or logic without loading the full table.

You can remove or adjust the step later when you are ready to work with the full dataset.

I hope this helps.If so, consider accepting it as solution.

Thank you.

Regards,
Pallavi.

[johnt75]

In Power Query you could use "Keep Top Rows".