Forum Discussion
Record data from sharepoint List
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.
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.Regards,
Xiaoxin Sheng
2 Replies
Alonso_96, check out the link below:
https://powerbi.microsoft.com/en-us/blog/how-to-expand-a-list-of-records-in-a-query/
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.Regards,
Xiaoxin Sheng
