Forum Discussion

Ejules's avatar
Ejules
New Member
5 years ago
Solved

Person/ People Field in SharePoint List - No Split available

Dear Community,   I'm fairly new to Power Bi, trying probably something quite basic 🙈.   In the SharePoint List, there are several custom fields which are of the type people/person. I crawled t...
Need Help
  • Ejules's avatar
    Ejules
    5 years ago

    ok, I think i solved it, turns out SharePoint List Blank is neither Blank nor null, this causes the issue.
    Workaround: Replace Non List Items with null, then it works as expected:

    1. Add a Step:

    2. in Custom Editor, replace the Step with:

    #"New Step" = Table.TransformColumns( #"PreviousStep", {{"YourColumn", each if Value.Is(_,type list) then _ else null}} ),

    3.  Normal Split is now available:

    4. 

    5. 

     

     

     

     

Ejules's avatar
Ejules
New Member
5 years ago

ok, I think i solved it, turns out SharePoint List Blank is neither Blank nor null, this causes the issue.
Workaround: Replace Non List Items with null, then it works as expected:

1. Add a Step:

2. in Custom Editor, replace the Step with:

#"New Step" = Table.TransformColumns( #"PreviousStep", {{"YourColumn", each if Value.Is(_,type list) then _ else null}} ),

3.  Normal Split is now available:

4. 

5.