cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
daviss62 Frequent Visitor
Frequent Visitor

Data load is not showing all rows in table

In one of the appended tables I created on the query editor side, I noticed that there is a significant amount of rows/records that are missing. Of the 7 files that make up the appended table, 5 of the files contain approx 24,000 rows of data, and 1 file contains just over 14,000 rows. Only 1 other file of the 7 loads all 24,778 rows without issue. However, when closing the query editor and going to the Data tab in the report view, it only shows 63,670 rows. The strange thing is that there was no issue with the first 6 files when I was working on some updates to the report last Thursday.

 

There is no filter being applied on the query editor side, so there would be no reason as to why the data/report view would not load all rows. I don't believe there is anything wrong with the relationships between tables that would cause the overall data for the table to be excluded. Please help.

 

Thanks,

Sean

1 ACCEPTED SOLUTION

Accepted Solutions
daviss62 Frequent Visitor
Frequent Visitor

Re: Data load is not showing all rows in table

I found the issue. The relationship had defaulted to 'one to one', but when I changed it to 'many to one', all of the expected rows showed.

 

-Sean

1 REPLY 1
daviss62 Frequent Visitor
Frequent Visitor

Re: Data load is not showing all rows in table

I found the issue. The relationship had defaulted to 'one to one', but when I changed it to 'many to one', all of the expected rows showed.

 

-Sean

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 284 members 3,128 guests
Please welcome our newest community members: