Forum Discussion
Retrieve certain number of rows per category
Hello all!
I have a data source that's a MySQL DB. Within that is a huge table (+10million rows) which I don't wish to refresh in its entirety everytime.
Keeping the first rows is simple, but how do I keep the first rows for each distinct category in the table?
In my case the data is identified by customer name, so how would I got about writing a query to retrieve the first 10,000 rows for each customer?
Thanks!
Anonymous,
Do you want to write specific query to get data when importing data from MySQL database into Power BI Desktop? If so, the blogs below describe that how to select first N rows for each category using MySQL query. You can refer to them.
http://www.sqlines.com/mysql/how-to/get_top_n_each_group
http://samalpramod.blogspot.com/2014/12/getting-top-n-rows-by-each-category-in.html
Regards,Lydia
4 Replies
Anonymous,
Do you want to write specific query to get data when importing data from MySQL database into Power BI Desktop? If so, the blogs below describe that how to select first N rows for each category using MySQL query. You can refer to them.
http://www.sqlines.com/mysql/how-to/get_top_n_each_group
http://samalpramod.blogspot.com/2014/12/getting-top-n-rows-by-each-category-in.html
Regards,Lydia