Power BI Desktop - Import Data - Navigator Graphic User interface (GUI) Icons meanings

[Anonymous]

Hello, I have some questions about the visual icons that are shown in the Navigator for Power BI Desktop application. 

I'm a little confused because I'm importing data from an Excel file that contains only one worksheet (and no structured tables), yet I'm given 2 options for importing, and the icons are different between the two. 

I can't really determine what's different, other than that the visual icons are slightly different and the new option has a 1 appended to the name (Query115, Query1151).  See screenshots below:

What do these icons mean for Query115 and Query1151?This is the source worksheet, as you can see, only one sheet. No hidden sheets, and no structured table.

Can someone explain to me what the difference is between the two options? 

Secondly, where I can also see the list of various visual icons and their meanings?  I couldn't find anything that could explain it for me. 

I'm operating under the assumption that Query115 is the worksheet, and Query1151 must be some kind of auto-derived/wizard worksheet without empty rows or something?  

[v-yulgu-msft]

Hi @Anonymous,

I was not able to reproduce this problem on my side. Please copy the worksheet "Query115" to a new Excel file and re-load it to desktop to see if problem persists. Besides, you could update your desktop version to the latest one for a test.

Regards,

Yuliana Gu

[Anonymous · Accepted solution]

Hey @v-yulgu-msft,

Thank you for your response.  I appologize for the long delay.  The data in that file is sensative so I could not share it out, and when I tried copying small snapshot of the data to a new excel file, I could not reproduce what I was experiencing.  

However, I thought more and more, and I think I figured out what it was...  (hint, it was Named Ranges)

Apparently my Excel file (which was sent to me) had a "Named Range", which I discovered when exploring the Formula ribbon bar, and clicking on Name Manager.  Then I saw there was defined name of "Query115" that referenced the range of cells that contained data.  I think when I imported the file into Power BI, it was able to identify this named range as an option for importing, which is why I was confused.  There's no easy/quick way to tell if you have a named range somewhere in your spreadsheets unless you check the Name Manager.  

Name Manager in ExcelSo I think we both learned something new!  You can go ahead and close/resolve this issue as solved.  

Sincerely,

Robert Eckman