Forum Discussion
SharePoint List - user fields do not translate
We have a Task Tracker list in SharePoint Online that we want to create some reports in Power BI on. One of the main fields in the list is "Assigned To" which is a "Person or Group" type. I c...
I suspect that this functionality has changed since the original post. When I query a SharePoint list, Power Query allows me to expand a Person field and specify which properties to display.
The problem I ran into relates to people that are no longer in the organisation. These rows were being filtered out from the results. The workaround I found was to expand the FieldValuesAsText column instead and select the Person fields I wanted returned. This ensured that rows with previous employees were included in my results.