When connecting to SharePoint online list AssignedToID showing List

[Makka]

I'm trying to display a sharepoint task list in powerbi, I require showing which user is assigned. In the AssignedToId i was expecting to see the id of the user the tasks are assined to, which I would then match up using "UserInformationList".

Instead all I am getting is "List" as the value in every row (see screanshot)? I'm not sure if i've missed something here.

Thanks for any help in advance

[Makka · Accepted solution]

I've figured it out 🙂 never realised you could juist "expand" the values.