Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! 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
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!