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

[OpsData93]

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!

[v-yingjl]

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.

[lbendlin]

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?