Forum Discussion

TootsiePatootsi's avatar
TootsiePatootsi
Regular Visitor
8 years ago

CSV values

Hi,   First of all thanks for reading this. I am new to PowerBI so I am hoping you could help me out.  I have the following data # Column Values Request #1 A,B,C Request #2 C,A ...
Need Help
dramus's avatar
dramus
Continued Contributor
8 years ago

Or...You can right click the "#"/Requests column, and select the "Unpivot Other Colu,mns" option. Same result.

TootsiePatootsi's avatar
TootsiePatootsi
Regular Visitor
8 years ago

Hi Dramus,

 

Thanks for helping me out here. Just to be sure I need to split them to columns right then unpivot the columns the all new columns?

  • dramus's avatar
    dramus
    Continued Contributor
    8 years ago

    Yes. Split and then unpivot.

    • TootsiePatootsi's avatar
      TootsiePatootsi
      Regular Visitor
      8 years ago

      Ill try it out, my data is quite large it takes quite a few minutes for the unpivot. Let you know what would be the result

       

    • TootsiePatootsi's avatar
      TootsiePatootsi
      Regular Visitor
      8 years ago

      Thats weird after I unpivot the new columns it showing this error

       

      We couldn't parse OData response result.  Error: A value without a type name was found and no expected type is available. When the model is specified, each value in the payload must have a type which can be either specified in the payload, explicitly by the caller or implicitly inferred from the parent value.

       

      Any idea what could be? Note the data was being pulled from sharepoint