Forum Discussion

Jameswh91's avatar
Jameswh91
Icon for Helper III rankHelper III
4 years ago

Too many rows being loaded

Hi, my sales table has started loading too many rows and i believe that it has essentially diplicated all rows.

 

Anyone know how this would have happend and how to rectify the issue?

 

Many thanks in advance for any help received.

Need Help
Show and Tell
Tips and Tricks

2 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 years ago

    How do you know that it is too any rows? What's your criteria?

     

    Power Query has column statistics, you can check the cardinality and unique count to see if you indeed have duplicates.

  • v-kkf-msft's avatar
    v-kkf-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Jameswh91 ,

     

    Do you mean that there are too many rows imported from the data source?

    What is your data source?

    Did you do any data transformation?

     

    Best Regards,
    Winniz