Forum Discussion

Seek08's avatar
Seek08
Icon for Helper I rankHelper 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
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Add filters on your dim table columns.

Seek08's avatar
Seek08
Icon for Helper I rankHelper 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.