Forum Discussion
Import sharepoint list like excel
Hi hjaf ,
So I think your solution relies on connecting directly to your SharePoint List.
Create a new data source and select :
SharePoint List or SharePoint 365 List
(depending on wether you use SharePoint online 365 or SharePoint server).
Then enter the URL of the home page of your SharePoint site, and select your list in the drop down menu.
More details here :
https://docs.microsoft.com/en-us/power-bi/desktop-sharepoint-online-list
Have a nice day and do not forget to Accept as solution if this is the case 😉
No, as I tried to explain with the initial post, this is what I have to work around. This is a method I'd normally use when getting data from sharepoint. But because the size and complexity of the list is such as it is, this method is going to take hours (if not days).
What I want to do is use the same method excel uses when importing sharepoint list with the ".iqy" file that sharepoint provides for an export to excel (see screenshot from earlier reply). This method seems to import a 2D table that a sharepoint list view generates, there is no need to expand records from the table and is extremely fast in comparison.
Please for heaven's sake somebody help us with this. I agree it is just unfathomably slow to bring list items from a SharePoint Online List items into an Excel spreadsheet or into Power BI using Power Query. It's really embarrassing that these Microsoft products and they integrate so poorly. Agreed, it would be so much faster just to be able to automate the export of large or multiple SharePoint lists using the .iqy export from SharePoint List to Excel method. Please Microsoft the entire utility of SharePoint is severely weakened by it's terrible connectivity with Power Query
Please see this post on how to get SharePoint List data ... but fast.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
