Forum Discussion

natyp's avatar
natyp
Frequent Visitor
7 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...
  • natyp's avatar
    natyp
    7 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!