Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Table error in Power BI column

Hello All,   I have a SharePoint list which has over 10 columns.   One of the column is Escalated to whom?. The cloumn type is person or group Allow multiple selections: Yes. That means user c...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous 

     

    Can you click on the space next to the Table to see the structure? If the table contains a column which has all the selected names, you can either transform current column or add a new column with the structure like this with add column as an example, but it still depends on your table structure

    Table.AddColumn(yourPreviousStep, "Custom", each Text.Combine([Escalated to whom][theColumnContainsNames], ","))

     

  • Anonymous's avatar
    Anonymous
    5 years ago

    I tried everything and it did not work. I contacted to Microsoft for support. They told me we cannot help you until you installed the latest version of Power B1 and test it.

     

    I downloded the latest version of Power BI and tested it. 

     

    The problem disappereed.

     

    Thnaks for everybody support on this.

respinosa1962's avatar
respinosa1962
Frequent Visitor
4 years ago

Was there ever any resolution to this?  I too need to have multiple selections allowed for my Business Owner field...I also submitted my issue on this forum.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi respinosa1962 

     

    Previously it was due to the version of Power BI Desktop for Anonymous , if you don't have error casued by that, you can refer to the code to combine the text