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.

MCY's avatar
MCY
Frequent Visitor
2 years ago

Hi Dersim,

 

I met exactly the same issue for one list whether other lists in the same SP site works perfectly. After two days I've found a workaround by
1) graphical user interface : Get Data -> SharePoint Online list -> select option "Implementation 2.0" before entered your Site URL -> OK.
2) power query : = SharePoint.Tables("YOUR_SITE_URL", [Implementation="2.0", ViewMode="Default"])

Hope it will help 😉