topic Re: Column Item Showing as [list] on powerbi in DAX Commands and Tips

Column Item Showing as [list] on powerbi

knishal — Wed, 24 Aug 2022 15:30:14 GMT

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?

Re: Column Item Showing as [list] on powerbi

tamerj1 — Wed, 24 Aug 2022 16:10:32 GMT

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.

Re: Column Item Showing as [list] on powerbi

knishal — Wed, 24 Aug 2022 16:49:05 GMT

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

Re: Column Item Showing as [list] on powerbi

Anonymous — Wed, 24 Aug 2022 16:56:19 GMT

Hi knishal ,

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

Re: Column Item Showing as [list] on powerbi

knishal — Wed, 24 Aug 2022 17:20:02 GMT

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]

Re: Column Item Showing as [list] on powerbi

tamerj1 — Wed, 24 Aug 2022 17:23:30 GMT

knishal

You nees to check your source data in the sharepoint list

Re: Column Item Showing as [list] on powerbi

knishal — Wed, 24 Aug 2022 18:39:15 GMT

tamerj1 there is no issue with the sharepoint list

Re: Column Item Showing as [list] on powerbi

Anonymous — Fri, 26 Aug 2022 05:51:05 GMT

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