PowerBi - Sharepoint People List appears show null value in query however [list] when in a visual

[SDisley]

A very odd one and it has annoyed me for days so I am poisting here should anyone experience the same issue.  These are the symptoms

1) When showing in a visual two value appear ((Blank) & [List])

2) When viewing in query editor the field is of type text

3) When viewing in query editor you can only see 'null', I cannot see [List] to expand it

4) If I export the Sharepoint List to Excel I can see the data

I am using the Sharepoint Online List 2.0 connector, have tried 1.0 and the ODataFeed connector also

The way I solved this and after many hours and then spotting pwoer query in Excel could read it....

1) In query editor filter the column and deselect (null) < yes...I cannot believe this is what helped me fix it!

2) You can now see [List] to be able to expand as new rows then expand to the data inside the list 🙂

I can only think it is because PowerBi Query also previews 1000 rows so I unluckily could never see [List] as the 1st row was beyond 1000 .. P.S> I even tried sorting the column in diff ways hoping the [List] option would pop up...it never did.  Someone may pop up with another way.

[v-sathmakuri]

Hi @SDisley ,

Please post your solution in the community and accept your answer as solution. This will help the other members find it more quickly.

Thank you!!

[v-sathmakuri]

Hi @SDisley ,

Please post your solution in the community and accept your answer as solution. This will help the other members find it more quickly.

Thank you!!

[v-sathmakuri · Accepted solution]

Hi @SDisley ,

Thank you so much for sharing this, This kind of post is incredibly valuable to the community. Definitely consider turning this into a blog post so others can benefit from your experience more easily

https://community.fabric.microsoft.com/t5/Power-BI-Community-Blog/bg-p/community_blog 

Please consider Accepting as solution to help the other members find it more quickly.

Thanks & Regards,

Rekha,

Customer Support Team.