Record data from sharepoint List

[Alonso_96]

Hello,

I need some help with some columns on BI. I got my data from a sharepoint list (the Sharepoint list have person columns to CREATED BY and MODIFIED BY) but when i tried to use this info in my inform i couldn't see it, and it looks like that in Edit Query:

Appears like Record in every row, but i only need the name of the Author and Editor, how can i extract that info for every row?

NOTE: I have full control of sharepoint list.

[v-shex-msft · Accepted solution]

Hi @Alonso_96,

It sounds like you received data that has combined multiple records and stored as list/records format.
In my opinion, I'd like to suggest you expand these fields to show the internal contents or try to use the record/list function to extract specific fields.

List.Alternate 

Record.Field 

Regards,

Xiaoxin Sheng

[DataInsights]

@Alonso_96, check out the link below:

https://powerbi.microsoft.com/en-us/blog/how-to-expand-a-list-of-records-in-a-query/