Forum Discussion

vgeldbr's avatar
vgeldbr
Helper IV
2 years ago

Power Query import of CSV file creates duplicate rows

I have a CSV file with just over 13,000 rows. It is an export from a system and is stored in a SharePoint library from where Power BI imports it. The query looks like this: let Source = SharePoin...
Need Help
Fowmy's avatar
Fowmy
Super User
2 years ago

vgeldbr 

Not sure how it happens without having a look at your query and debug. You can apply one more step to remove duplicates

Table.Distinct(#"Promoted headers", {"Instance ID"})