Forum Discussion

nfbelo's avatar
nfbelo
Regular Visitor
1 year ago

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)

 

 

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

Any idea what it might be?

Thanks in advance

Need Help

3 Replies

  • aatwellws's avatar
    aatwellws
    New Member
    1 year ago

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

     

  • nfbelo's avatar
    nfbelo
    Regular Visitor
    1 year ago

    Yes, everything's updated

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