Forum Discussion

OpsData93's avatar
OpsData93
New Member
4 years ago

Power Query Populating SharePoint List Data as "[List]"

Greetings,

 

I have connected a SharePoint List that contains a column (Model) that has a Type set as Lookup. The issue I am having is that the data is being pulled in as "[List].

 

I have provided a screenshots for your convenice:

 

SharePoint List

 

 

 

Power BI (populatnig [List])

 

Any recommendations on how to work around this would be very helpful.

 

Thank you in advance!

 

Need Help

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    You may be using the SharePoint.Contents  connector rather than the SharePoint.Tables connector.  Can you post a sanitized version of your Power Query code?

  • v-yingjl's avatar
    v-yingjl
    Community Support
    4 years ago

    Hi OpsData93 ,

    You can try to click the expand button for the list column to expand the list to row values in Power Query editor:

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.