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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
nfbelo
Regular Visitor

Datamart not loading all rows

Hi,

I'm having some trouble to find what is happening here??

In Datamart Power Query, after ETL, I have a table with 6 rows. Then a click 'Save' and it starts loading the data into the SQL and it clearly states that has loaded 6 rows (fig.1)

 

nfbelo_0-1730148964737.png

 

After the loading process, when I check the loaded table, it only shows 4 rows!??

nfbelo_1-1730148987455.png

Any idea what it might be?

Thanks in advance

3 REPLIES 3
nfbelo
Regular Visitor

Yes, everything's updated

I believe this Datamart has an issue, for instance, my Sales table isn't loading all rows as well

nfbelo_0-1730153970870.png

 

aatwellws
New Member

Have you run the refresh on the datamart and also have you checked that the data model has been updated? 

aatwellws_0-1730151757146.png

 

Yes, everything's updated

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.