cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper IV
Helper IV

Sample File Source Contains Kind Defined Name

Dear Community, 

 

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

 

Atanas_0-1611163720339.png

 

Thank you in advance, 

 

Atanas

1 ACCEPTED SOLUTION

Hello @Atanas 

 

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

View solution in original post

5 REPLIES 5
Super User III
Super User III

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

@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

Hello @Atanas 

 

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

@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.

Hello @Atanas 

 

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

View solution in original post

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session Drive Data Culture with Power BI: Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors