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.