Regarding Unpivot Table

[shuhn1229]

Hi,

Pretty simple question, I have a subset of my data that looks like this:

Activity 1	Activity 2	Activity 3
1/20/2021	1/19/2021	12/29/1988

I want to use the data as part of a Gannt chart or timeline visual, so I need all of the dates stacked into one column, as per the below:

Activity 1	1/20/2021
Activity 2	1/19/2021
Activity 3	12/29/1988

These data are located in a sharepoint. When I select the columns I want to transform and then click "unpivot selected columns" I get the error below:

DataSource.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.
Details:
    DataSourceKind=SharePoint
    DataSourcePath=https://xxx

Any ideas how to resolve this? Would it be helpful to have a transform step to copy the data I want to visualize to a new table stored within BI, and then only pivot that? How would I accomplish this?

Thank you!

Steve

[shuhn1229 · Accepted solution]

I figured this out. It had to do with the presence of cells containing records. I created a duplicate of the list and removed the columns with records, and used that duplicate to unpivot. It is working.

Steve