Column Item Showing as [list] on powerbi

[knishal]

Hi I have the following data coming from a sharepoint task list but its showing as [list] when it suppose to show user that i assigned to a task. How can i fix this?

[tamerj1]

Hi @knishal 

Looks like your data was not expanded as it should in power query. You need to go back to the query editer and properlt extract your data as required.

[knishal]

@tamerj1 the data is coming from a sharepoint task list. All of the other fields has data except for those

[Anonymous]

Hi @knishal ,

In Power Query editor you need to expand those columns like this.

[knishal]

I did that. Im getting the alert below when I expand the column and I also check in the sharepoint library they are user assigned to the task but its showing as "table" [list]

[Anonymous]

@knishal ,
Please check the [list] cell in Power Query Editor. If it's empty you cannot expand it.

[tamerj1]

@knishal 

You nees to check your source data in the sharepoint list

[knishal]

@tamerj1 there is no issue with the sharepoint list