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
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

    • dramus's avatar
      dramus
      Continued Contributor
      8 years ago

      If you delete that last step "Value", does the pivot succeed?

      • TootsiePatootsi's avatar
        TootsiePatootsi
        Regular Visitor
        8 years ago

        Hi dramus,

         

        The last step("Value") only shows up when I click on an error. Even I deleted it still does not work.