Forum Discussion

hjaf's avatar
hjaf
Advocate I
6 years ago

Import sharepoint list like excel

The sharepoint excel export function generates a .jqy file that I can use with excel, is there a way to use the same method for powerbi directly? I've been looking into OLE DB, which seems to be the ...
Need Help
gpfox's avatar
gpfox
Frequent Visitor
6 years ago

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