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,

 

I tried the unpivot feature but somehow all my columns shows error and 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

 

Thanks in advance

dramus's avatar
dramus
Continued Contributor
8 years ago

Which columns did you have selected when you tried to unpivot?

 

It should look like this before you do the unpivot:

 

 

Make sure all three of the "Column Values" columns are selected and then Right click on one of the headers and select "Unpivot Columns"

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