Forum Discussion

Agustina's avatar
Agustina
Frequent Visitor
5 years ago
Solved

Help - Sharepoint List to view all records

Hello colleagues,   I am currently working with a set of Sharepoint Online lists in Power BI and have problems when editing the data on Power Query. I've loaded the lists to the model, but some co...
Need Help
  • willcisler's avatar
    willcisler
    5 years ago

    Hi Agustina,

     

    You see the M query from when you clicked through?

    =#"Renamed Columns1"{[ID.1=47]}[TC]

     

    Solution: Place that into a custom column using an index to point to the row.

     

    like this

    create an index starting at zero

     

     

    New custom column

    #"Added Custom"{[Index]}[List_column]  ///Added Custom is my previous step

     

    Your new column will have the <--> split icon

     

     

    If you want a specific column right off the bat like 'title' then use:

    #"Added Custom"{[Index]}[List_column][title]

     

    If you want a specific column then add it at the end like this

     

    Curbal did a video on this, awesome channel for Power M

    https://www.youtube.com/watch?v=90EYX7pzVlE

    Kudos if that helps!

willcisler's avatar
willcisler
Frequent Visitor
5 years ago

Hi Agustina,

 

You see the M query from when you clicked through?

=#"Renamed Columns1"{[ID.1=47]}[TC]

 

Solution: Place that into a custom column using an index to point to the row.

 

like this

create an index starting at zero

 

 

New custom column

#"Added Custom"{[Index]}[List_column]  ///Added Custom is my previous step

 

Your new column will have the <--> split icon

 

 

If you want a specific column right off the bat like 'title' then use:

#"Added Custom"{[Index]}[List_column][title]

 

If you want a specific column then add it at the end like this

 

Curbal did a video on this, awesome channel for Power M

https://www.youtube.com/watch?v=90EYX7pzVlE

Kudos if that helps!