Forum Discussion

rtooker's avatar
rtooker
New Member
10 years ago
Solved

SharePoint Multivalue Fields Not Available in Power BI

When I connect PowerBI to a SharePoint list (either via the SharePoint connector or the oData connector), I am unable to see multivalue fields. Is there a way to deal with this?

  • Hi rtooker,

     

    There are no issues with multivalue fields, you have just to expand the column in order to see your data.

    Attention to the duplication of lines.

2 Replies

  • Rémi's avatar
    Rémi
    Icon for Resolver III rankResolver III

    Hi rtooker,

     

    There are no issues with multivalue fields, you have just to expand the column in order to see your data.

    Attention to the duplication of lines.

    • ALeef's avatar
      ALeef
      Icon for Resolver II rankResolver II

      Yup,  Just right click on the column name and "unpivot"