Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.