Forum Discussion
natyp
7 months agoFrequent Visitor
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...
- 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!
v-karpurapud
Community Support
7 months agoHi natyp
Thank you for the update. If you have any more questions, please let us know and we’ll be happy to help.
Regards,
Microsoft Fabric Community Support Team