Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Direct Query row limit in star schema

I have a fact table with well over a million rows that I am connected to with Direct Query. I need to create a detail view that just shows rows from that table. When I add fields from the fact to a T...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

I am simply trying to build a Table visual that displays row level detail. What I don't understand is why I can add as many fields as I want from my 4 million+ row fact table with no problem, but if I add just a single field from a joined dimension table to my table, I get the 1 million row limit error. What is it about adding a field from a joined table that causes the query to execute in such a way that it exceeds 1 million rows?

ManuGP's avatar
ManuGP
Advocate I
3 years ago

Hi! I also faced this issue. My conclusion was that the limit only applies when there are joins involved, if any of the individual query to each table is returning more than a million records before doing the join. And the workaround I found is to filter on fields of each table so that the 1 mill row limit is not exceeded.