Forum Discussion

respinosa1962's avatar
respinosa1962
Frequent Visitor
4 years ago
Solved

Error when expanding a column: No columns were found

I have a SPO list where a column named "Business Owner" is a people picker field.  When I try to connect to it using 2.0 (Beta), I get this error:   When I connect using 1.0, the preview is t...
Need Help
  • respinosa1962's avatar
    respinosa1962
    4 years ago

    I got this tip from a colleague.  There is a field called 'FieldValuesAsText'.  Expanding that one allowed me to get the field I needed.

respinosa1962's avatar
respinosa1962
Frequent Visitor
4 years ago

I got this tip from a colleague.  There is a field called 'FieldValuesAsText'.  Expanding that one allowed me to get the field I needed.

  • Catonemillion's avatar
    Catonemillion
    New Member
    2 years ago

    Love Power Bi it's always just one more thing to do, great solution thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago
    great!! Thanks!! Worked for me !
  • hisham89's avatar
    hisham89
    New Member
    1 year ago

    Hi respinosa1962,

    I'm having the same problem - "No cloumns were found" in expanding one of the column in the XML table.  

     

    Can you explain further on how to get to "FieldValuesAsText" and expand it, it seems I couldn't find the field anywhere inside the table?  Thanks.

  • ninjaryder1st's avatar
    ninjaryder1st
    New Member
    1 year ago

    Can you expand on where this 'Field value as text' is found or selected?    I have the same exact issue with "no columns were found" and the SP request fialed error (500) and have no idea where to find 'FieldValuesAsText" from inside PQ.   thanks!