Help - Sharepoint List to view all records

[Agustina]

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

[Agustina]

Many thanks @willcisler  I have no idea I could do that!

It worked! Great tutorial from Curbal too.

😀

[willcisler · Accepted solution]

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!