Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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 ...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    amitchandak Thanks for replying. All those methods work only after fetching all the data.

     

    I want to fetch only top n from sql server itself. I think I have made my need clear. Please be specific.

     

    If you did not get my need right pls ask where exactly you want me to make it clear.

     

    Thanks!

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi amitchandak , does applyting top N filter query only top N from SQL server or query everything and apply after getting data ...?