Forum Discussion

mrsid2201's avatar
mrsid2201
Regular Visitor
7 years ago

Distinct column values from SharePoint Lookup

Hi,   I'm pretty new to Power BI.  I have created a project status dashboard in Power BI Desktop. My data is being pulled from a Sharepoint online list.  My online list columns are as follows:  ...
General Comment
Need Help
Show and Tell
Tips and Tricks
tex628's avatar
tex628
Community Champion
7 years ago

For a project including 3 people i'd say you need to create 2 additional rows. This can be done by a combination of split column and unpivot:

Starting tableSplit column by ";"

Highlight your new columns and then press unpivot. 

You should get a row for each participant in each project.

  • mrsid2201's avatar
    mrsid2201
    Regular Visitor
    7 years ago

    I was able to split the columns but unpivoting the new columns caused the new columns to disappear and the following error:

     

    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://#######/sites/it