Forum Discussion

vgheorghe's avatar
vgheorghe
New Member
7 years ago
Solved

Power quedoury refresh duplicating rows

Hi,   I have an issue with the refresh in power query. I use a "get data from folder" option, and in this folder i store data for each month that has passed. I have run today the refresh and it dou...
Need Help
  • vgheorghe's avatar
    vgheorghe
    7 years ago

    Hi,

     

    I have copied the data from the original source file, paste it into a new one and upload this one. All looks good.

    Weird....

     

    Thanks

jwin2424's avatar
jwin2424
Resolver I
2 years ago

I had this same issue. It would duplicate a few files, but not all of them. When you expand the tables, a custom kind shows up as a new column. Under custom kind, I had Sheet and DefinedName as the values. I filtered only to show data with the value Sheet (the name of the sheet in the excel file itself) and it resolved the issue.