Forum Discussion
Extract Data from sharepoint
Hello,
I wonder how extract data from my company's 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.
4 Replies
- Go to Home → Get Data → SharePoint Folder
- Enter the SharePoint site URL
- Power BI will list all files in that site
- Filter to your file and open it.
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.
Hi Oemad987,
Have you had a chance to review the solution we shared by cengizhanarslan vojtechsima ? If the issue persists, feel free to reply so we can help further.
Thank you.
Hi Oemad987,
Checking in to see if your issue has been resolved. let us know if you still need any assistance.
Thank you.
