Sample File Source Contains Kind Defined Name

[Anonymous]

Dear Community, 

Can anyone help me understand what the yellow ones are? I swear I have only Kind "Sheet" in my RAW Data.

Thank you in advance, 

Atanas

[lbendlin]

those are hidden system sheets that are created when you start filtering the visible sheets.  You can ignore them.

[Anonymous]

@lbendlin 

Thank you, is there any way to remove them before upload them to power query? Asking as i appended them and power bi calculated Asia and Europe x 2 - doubling all the rows. It was really frustrating until I understand what the problem was.

Atanas

[Jimmy801]

Hello @Anonymous 

Power Query can read different ranges of a file like sheets, tables, named ranges.

What you can do is to filter on column "Kind" to the type you want... like sheets I suppose.

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

[Anonymous]

@Jimmy801,

Thank you, i realized that, but what i need to understand is why this is happening? I really need only the sheets. I made some manual changes on my RAW data using filters, but i removed them. For some reason PQ now adds them as additional ranges.

[Jimmy801 · Accepted solution]

Hello @Anonymous 

as I wrote you have to filter this table on the column "kind" so you are able to get rid of the other ranges. Consider that also a printing area is a defined range name.

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy