Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I'm picking up some excel files from Sharepoint and I'd like to be able to see when they were created. However, PowerQuery is only presenting when the file was created on Sharepoint, not its original creation date.
If I download one of the files, open it in Excel and go to File > Info, I can see the real created date:
I've loaded the full attributes from Sharepoint, they gave me values for Size, Content Type and Kind. Is there any way to read the metadata from within the excel file? The only options I see when I merge the files is the names of each of the worksheets contained in them, no metadata. I don't have write-permission to the Sharepoint repository.
I thought that would do it, but sadly not:
Still get Metadata groupings that are not required.
Hi @pmay ,
Try following this thread to see if it works for you:
It basically uses the ODATA connector to the SharePoint bin/listdata respository to get all files metadata.
Pete
Proud to be a Datanaut!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.