Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
From Sharepoint, I am able to extract a table containing filenames, file extensions, and dates...
https://learn.microsoft.com/en-us/power-query/connectors/sharepoint-folder
However, I would like to know what user modified the file.
I cannot find how to add this field to the query.
This is a similar request that was not answered either.
https://community.fabric.microsoft.com/t5/Power-Query/How-to-Power-BI-list-Document-Property-Last-Mo...
I don't seem to have that column.
Attributes do not contain either Editor or Author
Related: https://community.fabric.microsoft.com/t5/Power-Query/How-to-Power-BI-list-Document-Property-Last-Mo...
On the first steps of the query, identify this record column (FieldValuesAsText)
Expand this column by checking Editor (user who last modified) and any other column you need.
And that's it! 🙂
Proud to be a Super User!
The field you refer to is not in the table retrieved in that initial query
If you refer to this link you will see the initial data under the item 3 of "Connect to a SharePoint folder from Power Query Desktop"
Where do you see this field under ?
https://learn.microsoft.com/en-us/power-query/connectors/sharepoint-folder
 
					
				
				
			
		
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
