Forum Discussion
Report with huge data not loading data in Power BI Desktop and PBI service
Thank you all for responding. I did not realize that there's a limit of rows to be displayed when using Direct Query. What makes it more confusing is that we have another report that has even more rows than what I'm working on and data displays fine. What I will do is break out the report into several reports by year. You guys are right, it does not make sense to go through millions and millions of rows.
Thank you again for your responses. Appreciate it very much!
Resolver II
I think the million row limit is a limitation of Direct Query, but it does depend on how things are set up. You might need to look at the construction of what you've put together and maybe try to break it down. I think the idea with Direct Query is to use query folding if possible, or have the data already shaped and summarized if you can.
I've come across this limit before as well and had to think of a different design. You could try adding, (or starting with), a dummy table that is local to the report. If you then add direct queries, you should have the option for Mixed Mode. This combines Import and Direct Mode and may enable you to workaround the limitation. There are also settings related to memory in the Options pane that you could try adjusting. I know this isn't a specific solution but I hope it helps.