Person filed not expanding in Power Bi desktop

[n1112997]

Hi

I'm having issues with a SharePoint list and a person field while building a fleet management report.  I want to report on Current Drivers Display name field.

If you compare the Current Driver (SharePoint Person column) and Created By (the default sharepoint field) you can expand the default one but not the other.  

In Power BI you can drill down and see the values in the data but it is missing the  icon to extract the fields into the wider data set.

Am I being thick or is there another way to do it?  

Many thanks in advance.

[v-angzheng-msft · Accepted solution]

Hi, @n1112997 

Select the Current Driver column, use the Replace Values feature, replace the blank with null and try again

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[n1112997]

Thank you very much!  That had me completely baffled.