Forum Discussion
query only top n from sql server by a column within specified date range
I have a large set of data that exceeds power bi row limits and am getting operation timeout. I want to query only top n rows from sql server based on one column and also want to have date filter on ...
Anonymous , Top on anything you can get by Rank or using top N filter at the visual level
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/367415
Hi amitchandak , does applyting top N filter query only top N from SQL server or query everything and apply after getting data ...?