Sharepoint site file properties

[f_a_b]

Hello

I'm trying to create a report to show the date of file creation of all files in Sharepoint, ideally a report for all files on all sites. Can someone please point me to a solution?

[v-juanli-msft]

Hello @f_a_b

You can use the sharepoint folder connector and merge these files as shown below:

https://www.enjoysharepoint.com/combine-multiple-files-from-sharepoint-in-power-bi/

Best regards
Maggie
Community Support Team _ Maggie Li
If this post helps, please consider accepting it as the solution to help other members find it more quickly.

[f_a_b]

Thanks Maggie, my problem is that I want to get all files from all SharePoint sites though, is there a way to do that in one query?

[amitchandak]

@f_a_b , refer if this can help

https://medium.com/@wkrzywiec/getting-data-from-the-latest-file-in-a-folder-using-power-query-51dfa4...

[nandukrishnavs]

@f_a_b 

You could use the SharePoint Folder connector.

You have to provide a site URL. Then you can find all the files inside that site along with file properties. 

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

[nandukrishnavs]