Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Paulyeo11
Impactful Individual
Impactful Individual

How to reduce row data from 510 row to 20 row ?

‎12-09-2020 02:52 AM

Hi All

 

I have a data load into PBI.  it have 510 row of data. 

 

May i know how to reduce the number of row to first 20 row ?

 

https://www.dropbox.com/s/v4wgfd9pp0affr5/COMPETITOR_V003.pbix?dl=0

 

My PBI file from above link :-

Paul

Labels:
Message 1 of 3
308 Views
0
1 ACCEPTED SOLUTION
PhilipTreacy
Super User
Super User

‎12-09-2020 03:05 AM

HI @Paulyeo11 

In Query Editor -> Keep Rows -> Keep Top Rows -> 20

keep-top-rows.png

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

Message 2 of 3
305 Views
0
2 REPLIES 2
PhilipTreacy
Super User
Super User

‎12-09-2020 03:05 AM

HI @Paulyeo11 

In Query Editor -> Keep Rows -> Keep Top Rows -> 20

keep-top-rows.png

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Message 2 of 3
306 Views
0
Paulyeo11
Impactful Individual
Impactful Individual
In response to PhilipTreacy

‎12-09-2020 03:27 AM

Hi Phil

Thank you very much , it work.

Paul 

Message 3 of 3
281 Views
0

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

View All