Extract Data from sharepoint

[Oemad987]

Hello, 

I wonder how extract data from my company's sharepoint 

[vojtechsima]

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.

[cengizhanarslan]

1. Go to Home → Get Data → SharePoint Folder
2. Enter the SharePoint site URL
3. Power BI will list all files in that site
4. Filter to your file and open it.