Changing a small amount of data results in duplicate rows in power query

Faisal Yunianto

New Member
Joined
Apr 21, 2023
Messages
13
Office Version
  1. 365
Platform
  1. Windows
I have a question about power query, every day at work I have to download files from the company system, at that time there was a system error so I changed 4 cells and added a yellow highlight (as a marker that I changed) to the file that I downloaded earlier. when I process the power query that I have created, I don't know why the power query counts many rows twice. To clarify, 1 file has 20,853 lines after processing it becomes 41,706. this case has been resolved by deleting duplicate data but I am curious why this could happen. can anyone explain the reason? does changing the data and giving it a yellow highlight have a significant effect?
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
Power query does not see formatting, so something else caused the issue. Perhaps there are duplicate files, or duplicated data in the file, or you referenced the workbook with the previous query as well.
 
Upvote 0
Power query does not see formatting, so something else caused the issue. Perhaps there are duplicate files, or duplicated data in the file, or you referenced the workbook with the previous query as well.
Thank you for responding to my thread. I also think like that. If the original data is duplicated, I will make sure it is not because the data I processed is transaction data and has a unique transaction number
 
Upvote 0

Forum statistics

Threads
1,216,500
Messages
6,131,016
Members
449,615
Latest member
Nic0la

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top