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

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.