Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Suppose I've loaded 10 tables in Power Query Editor of Power BI Desktop. Each table consists of 1 million rows. I want to only load only 3000 rows from each table into the Power BI Desktop data model. How should I do It?
@ThisIsVS Nope 🙂 , You have to do this one by one because the tables are in power query separately.
Hi @ThisIsVS
If you are using SQL, you can add "select top 3000" to the beginning of the query. You can also follow the "Keep Top Rows" steps below on Power Query to set this restriction in Power Query.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best regards 🙂
Ezgi Naz Aslankara
@Anonymous Do I have to Repeat the "Keep Top Rows" step for all the tables?
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
9 | |
9 | |
8 | |
6 | |
6 |