Forum Discussion

radoslavov91's avatar
radoslavov91
Regular Visitor
1 year ago
Solved

Not all rows pulled from Dataverse

Hi All, something very strange is happening. I've just created a new Power BI file with data from Dataverse. I'm pulling all accounts from our environment. I'm using my system admin account. In D...
Need Help
  • radoslavov91's avatar
    radoslavov91
    1 year ago

    The solution was simpler! I just cleared all permissions from the datasource settings. Apparently something was cached, so I started fresh, and now I can see everything properly 

radoslavov91's avatar
radoslavov91
Regular Visitor
1 year ago

So, there are three connectors: Dynamics CRM Online (legacy), Dynamics CRM (Dataverse), and Dataverse only (part of Power Platform). neither returned the amount of records I was expecting.

 

Regardnless of the connector used the Query is always refeering to 

let
Source = CommonDataService.Database("vossfluid.crm4.dynamics.com"),
dbo_account = Source{[Schema="dbo",Item="account"]}[Data]
in
dbo_account

 

This happend recently because if a load some of the previous reports developed by myself before refreshing the data i can see around 3000 Accounts, after i refresh the report its updated to 400.

 

I've tested both Import and Direct Query and both shows the same 815 Accounts instead of 4225