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

Neither of these actions worked. I even created a new report using the Dataverse connector, connected only to the Accounts table, and still 815 record. My System user's account, as I show on the picture, can be seen 4225 Account in CRM, and netiher one of them are owned by me as I don't own records as a system admin. After loading the dataverse connector the advanced editor query still shows: let
Source = CommonDataService.Database("myorg.crm4.dynamics.com"),
dbo_account = Source{[Schema="dbo",Item="account"]}[Data]

And if try to use the query provided here:

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

 

It gives me the following error message:

The import Dataverse.Database matches no exports. Did you miss a module reference?