Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Directquery Row limit

I have a table having more than 50 lacs of data and is in directquery mode. There are Slicers and matrix visuals on the report page. while loading the matrix visual I am getting error of "the results...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi Anonymous 

    This blog will help you understand why this error occurs and how to increase the row limit to adapt your scenario.

    https://www.sqlbi.com/articles/tuning-query-limits-for-directquery/

     

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

There is one to Many relationship between the table with cross filtering direction set as Single. The error generally occurs when slicers have All. If any specific value is selected then it works as expected. 

 

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    6 years ago

    Hi Anonymous 

    This blog will help you understand why this error occurs and how to increase the row limit to adapt your scenario.

    https://www.sqlbi.com/articles/tuning-query-limits-for-directquery/

     

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.