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!
Community SupportHi natyp
Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to pbix1 , Natarajan_M and danextian for sharing valuable insights.
Could you please confirm if your query has been resolved by the provided solution?If you have any more questions, please let us know and we’ll be happy to help.
Regards,
Microsoft Fabric Community Support Team.
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!