Power Query Duplicating Rows

[MJEnnis]

After refreshing my data imported from an XLSX file, I noticed that my promoted headers were suddenly appearing in a row. When I checked, it turns out that the header row had been duplicated. I removed that row, but then I noticed that many other rows have been duplicated. In PBI. I checked the Excel file, and the none of these rows are duplicated in the data. So something is happening on the query end. It is weird because there are no steps which might cause this (no pivoting or unpivoting, no ammending or merging). Does anyone have any ideas why PBI would be duplicated rows like this? I did just update the desktop app after a couple months. Maybe a recent update?

[MJEnnis · Accepted solution]

Yeah, just didn't know how to search for it. I had the filters turned on. But turning them off does not fix the problem. This is the fix: Solved: FilterDatabase file error - Microsoft Fabric Community

[MJEnnis]

Ah... maybe it is because I had filters turned on in the Excel file. Refreshing with them turned off now...