Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
tmillerch
Frequent Visitor

Return records size cannot exceed 83886080. Make sure to filter result set to tailor it to report.

tmillerch_0-1676422305544.png

So, I have this error...  When I try to filter within the Power BI report, I get this message.  I must be filtering it at the wrong point.  Am I suppsoed to filter this in Dataverse and not within the Power BI report itself?  If I do need to use the same data (as it is a yearly report), should I just make a new Dataverse table starting from the beginning of this year and deal with the problem "x" months down the line?

1 REPLY 1
AllisonKennedy
Super User
Super User

I'm not super familiar with querying from dataverse, just found this article: Use SQL to query data (Microsoft Dataverse) - Power Apps | Microsoft Learn

 

Which implies Dataflows might be helpful, but I believe you should be able to get query folding to happen from desktop as well. Are you filtering in the Power Query as the first step after source step? Try that first and report back if it helps. 

 

This article may be useful if you're trying to use native query: SpeedTip - EnableFolding option for Dataverse Native SQL Power Queries (linkedin.com)


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.