Forum Discussion

bammyd36's avatar
bammyd36
Frequent Visitor
3 years ago
Solved

Data appears twice in power query

Hello everyone,   I have an issue with my data. When I get new data from my data source (Athena), it duplicates itself in power query. Right after the last row, the same data appears again from the...
Need Help
  • RocketRod's avatar
    RocketRod
    3 years ago

    Verify your data source doesn't have duplicated data. If the source is Excel delete all the rows in the workbook after the last know row.

     

    If that doesn't fix it post your m code. Also if it's duplicating the data, select all columns and click Remive Duplicates....however that's a poor band aid as you really want to find the root cause of the duplicates.

  • bammyd36's avatar
    bammyd36
    3 years ago

    Thank you for your suggestion.

     

    The problem was from the data source so I corrected it from there and added index column.

RocketRod's avatar
RocketRod
Frequent Visitor
3 years ago

Verify your data source doesn't have duplicated data. If the source is Excel delete all the rows in the workbook after the last know row.

 

If that doesn't fix it post your m code. Also if it's duplicating the data, select all columns and click Remive Duplicates....however that's a poor band aid as you really want to find the root cause of the duplicates.