Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
SDisley
Regular Visitor

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])

SDisley_0-1744012249040.png

 

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.

1 ACCEPTED SOLUTION
v-sathmakuri
Community Support
Community Support

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.

View solution in original post

3 REPLIES 3
v-sathmakuri
Community Support
Community Support

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
Community Support
Community Support

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
Community Support
Community Support

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.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.