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.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

Top Solution Authors
Top Kudoed Authors