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

Faisal Yunianto

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.
Sort by date Sort by votes
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
RoryA said:
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.
Click to expand...
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
You must log in or register to reply here.

Similar threads

E
  • Question
Power Query to automate payroll entry
Replies
0
Views
219
egspen2
E
BrettOlbrys1
  • Question
Power Query Issue
Replies
1
Views
336
Matt Allington
M
L
  • Question
Error with making hour column from datetime column
Replies
0
Views
198
LambChoptheKid
L
J
  • Question
PQ - Declaring Data Type in Defined Data Table
Replies
9
Views
379
johnny51981
J
L
  • Question
Excel Power Query Refresh Does Not Update
Replies
2
Views
678
legalhustler
L

Forum statistics

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

Share this page

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