Question regarding Power Query and List

[gmc72101]

Hello everyone,

I am fairly new to Power BI.  I just passed my PL300 Cert exam and I have some experience with Power BI.  I have a question regarding SharePoint LIST and connecting to SharePoint using Power BI.   At my job, I am trying to connect to a LIST that exist on a sharepoint site that I have access to.  I cant edit this list, add entries and do everything needed.  

When I connect directly to SharePoint, it allows me to select the LIST.  But when I look at the actual column in Power Query, I do not see the data I expect to see for the "Offering" column.

Long story shore, the Offering column should have a product name by it.  This product name is not a free form feild.  This field is a drop down taht must be selected when updating the LIST. 

Here is a screenshot of what I see on our SharePoint List.  As you can see the offering states Dell 7440. 

But in Power Query it looks like a table gets created with 3 columns.  The 3 columns do not represent the actual data from the LIST.  When I expand the columns I see that there appears to be another column (termguid) that needs to be linked up with another table. (i think?).  

Maybe I am not understanding this but, I would expect this column to show things like Dell 7440, and not other columns?  Am I wrong to expect to see the products we offer of which are displayed on the list for "Offering" column?

My question is as follows:

When a list gets created, are these tables created Automatically in SharePoint, or does someone need to manually create these tables on the backend?  I am trying to determine why it looks this way. 

Not sure if anyone can help but thank you.   

NOTE: I have searched the internet and have not come up with much.  I know how to combine and join tables, and from what I can tell, there are no other tables that show a similiar structure to try and create a join. 

Thanks!

[lbendlin]

Instead of "SharePoint List" connect to "SharePoint Online List", specifically V2.  That will expand these lookup columns for you automatically. 

[gmc72101]

Thanks for your response but, it looks like now I get an error message when I try and connect.  I think at this point this may be an issue that I may need to reach out to my organization for.  Thank you for your suggestion, I greatly appreciate your time!