Forum Discussion
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 columns of it show "List" instead of the records (analysts names in this case) I see on Sharepoint.
When I try to click on List I only get that specific record for that row, but cannot get the full data to be displayed.
Do you have any suggestions I could try to get the full view of the full data?
Thanks in advance,
Agustina
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!
2 Replies
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!
Many thanks willcisler I have no idea I could do that!
It worked! Great tutorial from Curbal too.
😀