Extract Data from sharepoint

Hey, Oemad987 ,

I have blogs how to get data from SharePoint List or SharePoint Files:

https://www.vojtechsima.com/post/fix-slow-refreshes-faster-way-to-load-sharepoint-files-in-power-bi

https://www.vojtechsima.com/post/how-to-fix-slow-sharepoint-list-refresh-in-power-bi

If you want a general rule, use SharePoint.Contents over SharePoint Files (as that is slower).

If you go to Get Data, click Blank Query, then paste this:

= SharePoint.Contents("https://tenant.sharepoint.com/sites/siteName", [ApiVersion=15])

Fill the tenant and siteName and you'll get your files, then it's simple navigation with clicking.