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
amitchandak's avatar
amitchandak
Super User
6 years ago

Dax functions like summarize and summarize columns may actually get that in power and calculate it.

Can you let us know what you are trying to achieve?

Also, refer Query Reduction

https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about

https://www.youtube.com/watch?v=4kVw0eaz5Ws

 

And mix mode :

https://community.powerbi.com/t5/MBAS-Gallery/Aggregation-and-composite-model-Microsoft-Power-BI-fast-and/td-p/712871

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin

  • 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.