Forum Discussion
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...
Add filters on your dim table columns.
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.