Forum Discussion

Seek08's avatar
Seek08
Helper I
2 years ago

Direct Query 1 Million Limit

Direct Query has 1M limit as we all know. I have a table visual and I know the total number of rows is less than one million, but still I am getting that limit error, I read somewhere that it might b...
Need Help
Seek08's avatar
Seek08
Helper I
2 years ago

Hi All,

I have a PBI report in Dual mode. I have a table visual with multiple dimensions and measures with lowest grain level data and that visual is returning more than 1M rows which is limit of PBI. Now can I limit my table visual to return less than 1M rows or top 999999 rows based on any of the KPI so that visual won't throw any error. Model is Star Schema(Dim tables Dual Mode, Fact Table Direct Query).

lbendlin's avatar
lbendlin
Super User
2 years ago

Add filters on your dim table columns.

  • Seek08's avatar
    Seek08
    Helper I
    2 years ago

    Yes that is one of the solution, customer suggested that you apply limit of 100K on your query itself so that it won't impact load. I don't think its practically applicable as direct query are generated in background and we don't have control over it, I want to make sure I am correct before saying that its not possible.