Forum Discussion

natyp's avatar
natyp
Frequent Visitor
9 months ago
Solved

Report with huge data not loading data in Power BI Desktop and PBI service

I'm working on a simple report with just a table as a visual but with huge data. I have done the following but the report still fails to load. - Used direct query - Added a measure so that visual i...
Need Help
Tips and Tricks
  • natyp's avatar
    natyp
    8 months ago

    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!

danextian's avatar
danextian
Icon for Super User rankSuper User
9 months ago

That is the expected behaviour. What the table visual does is computationally expensive so it gets throttled. Use slicers instead and inform your users to use these to be able to see the data. Who would have the  time anyway to be scrolling through thousands if not millions of rows?