When working on a report with huge data sets, its a huge pain when you're trying to clean up the Power Query side and applying the changes and importing the whole data set only to find out that it is...
I know the custom query function is available where you can manually select only to top n row. I mean by sample here is by taking bit of pieces here and there according to field available, such as date. 10% of the total data source containing a data through out the year = every bit of day in the month are taken into account, not only the top 10% which most probably going to take only the earliest 10% of data which is on January / February only.
