Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Decrease amount of data received from Direct Query

Hallo everyone,   I'm using a SQL database, containing over hundreds of million rows. To get data the database without too long loading times, I'm using slicers to limit the size of it. however, ev...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hello v-kelly-msft ,

 

if I do this, I am forced to switch to Import mode, which I want to prevent because the data needs to be as fresh as possible.

Also, I need all the data contained within the database; by filtering them in Power Bi Desktop I can minimize the amount of data. If I were to filter them before loading, I wouldn't have access to every data.

 

Filtering in Desktop works, however Power Bi Desktop always sends queries ignoring the allowed amount to be returned. Often, the visuals end up showing the error that more than a million rows have been loaded (Because the are sometimes cases where the user hasn't selected anything and canceling the big query doesn't work by reselecting anything). In my case, I just want to see about a 1000 rows. If there's somewhere a option to change the value such as: "Restrict the amount of data received by queries in Direct Query to: ", this will be every amazing.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi apentyala,

     

    thanks for that! I believe my queries became a little faster.

     

    Nonetheless, my problem still doesn't really subside: the time needed is too long because the amount of the data/count of rows loaded for the visuals doesn't change.