Power Query import of print area is causing duplicates

[Monsignor]

Is this new? I made queries 7 months ago and within the past 2 weeks I've been getting random duplicates.

The query brings in about 50 sheets worth of data, and there might be 1 or 2 that are duplicated. I just noticed this activity in the image below. The duplicate is happening on this file because Sheet1 is being imported as well as _xlnm.Print_Area.

When I go filter that print area out, everything is fine.

I don't know if I just missed something 7 months ago; if the workbook user did something; or if Microsoft changed something.

Any ideas where I can begin to look for what's different?

 

[Comfy]

It's probably that a user has set a Print Area and the print area didn't exist when you created the Query.

Assuming you are using Excel.Workbook?

There should be a column called [Kind] which you can use to filter on "Sheet"

let
    Source = Excel.Workbook(File.Contents("C:\Book1.xlsx"), null, true),
    #"Filtered Rows" = Table.SelectRows(Source, each [Kind] = "Sheet")
in
    #"Filtered Rows"

 

[Monsignor]

Yup! That's exactly what happened.
Thanks for the tip. I'll incorporate this to prevent future time bombs.