How to stop duplicate records coming in BI after creating Generic Source

Hi Expert,

I created a Generic Source in ECC using View. When i loaded data using this source in BI , I am getting 10 million records but actual records are only 10000 , all others are duplicate. How can i stop these duplicate reocrds coming in BI?

Can i do something in Generic source so it won't pick any duplicate reocrd?

Thanks

Pawan