Datamart not loading all rows

[nfbelo]

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)

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

Any idea what it might be?

Thanks in advance

[nfbelo]

Yes, everything's updated

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

[aatwellws]

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

[nfbelo]

Yes, everything's updated