Not all rows pulled from Dataverse

Hi radoslavov91 ,

Thank you for reaching out to Microsoft Fabric Community.

This is a common issue when working with Dataverse in Power BI. Even though you're using a System Admin account, there are a few things that can limit the number of rows you see:

The reason Why you're only seeing 815 rows:
Old Connector - You're using the Common Data Service (Legacy) connector. This often applies hidden filters or permissions.

Security Roles - Power BI still respects Dataverse security roles. Even admins can be limited by things like business units or ownership of records.

Auto-applied Filters - Sometimes, Power BI applies hidden filters from relationships or related tables (like lookups or navigation columns).

You can do following steps to fix it:

1.Use the new Dataverse connector
Replace your current query with this:

let
Source = Dataverse.Database("myorg.crm4.dynamics.com"),
Account = Source{[Name="accounts"]}[Data]
in
Account

2.Check for hidden filters
In Power Query, look at the "Applied Steps" and make sure nothing is reducing your rows.

3.Check security in Dataverse
Even if you're an admin, confirm your account can access all records, not just the ones you own.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thank you.