Dataflow duplicates rows from an SQL DB

[BerlinAlexander]

I created a dataflow with around 6 queries. The queries are from different sources: some flat files on the sharepoint, some SQL databases.

One of the SQL DB query within the dataflow got refreshed in such a way that every line is duplicated. In the meantime I've tried re-running it and the result is exactly the same. Every row is duplicated.

I'm at a loss what happened. I've checked the data directly in the DB and it's correct. There are no duplicates.

The code for this query is:

let

  Source = Sql.Database("server name", "database"),

  Navigation = Source{[Schema = "dbo", Item = "CurrentYear"]}[Data],

  #"Renamed columns" = Table.RenameColumns(Navigation, {{"51UXP104E9IRKT8S9ZGX29XDTGARAN90", "% Order Days Elapsed"}, {"0CUST_SALES", "Customer Hierarchy"}, {"0MATERIAL", "Material"}, {"20CUST_SALES", "Sales"})

in

  #"Renamed columns"

Any ideas what could have happened?

[v-zhenbw-msft]

Hi @BerlinAlexander ,

Does Power BI Desktop duplicate all rows when you connect the data source? How many more rows are duplicated?

Could you please post some screenshots of Power BI and data sources? Please don't contain any Confidential Information or Real data in your reply.

Maybe you can refer the following posts.

https://community.powerbi.com/t5/Desktop/Duplicate-data/td-p/72200

https://community.powerbi.com/t5/Desktop/Error-while-Refreshing-data-on-power-bi-Desktop/m-p/1096007...

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.