Forum Discussion
Power BI Desktop - Import Data - Navigator Graphic User interface (GUI) Icons meanings
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
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
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