Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Show more than 1 Million Rows in Direct Query

Hi All,  I have a Power BI Report connected to an Azure SQL DB through direct query and hosted in a premium capacity Workspace and embedded in a Web Application. The Report contains some KPI's at...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi Anonymous ,

     

    "There's a fixed limit of 1 million rows placed on the number of rows that can be returned in any single query to the underlying source."

    Try to optimize this query, such as using filters, slicers, etc.

     

    Best regards,
    Lionel Chen

    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

    Hi amitchandak ,

    Thanks for the Answer, I'm going to create a view for only the columns required by PowerBI.
    But that still does not fix the issue of the row limit.

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

      Hi Anonymous ,

       

      "There's a fixed limit of 1 million rows placed on the number of rows that can be returned in any single query to the underlying source."

      Try to optimize this query, such as using filters, slicers, etc.

       

      Best regards,
      Lionel Chen

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.