Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to 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.
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!!
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!!
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.
Check out the July 2025 Power BI update to learn about new features.