Aug 02 2018 01:47 AM - edited Aug 02 2018 01:50 AM
Using Excel 2013 it was possible to import the list(s) data from SharePoint online into excel using OData option. This excel when uploaded to SharePoint document library, It was possible to perform the real-time refresh of the data so that the excel pulls the information directly from the SharePoint list into the excel online(not from excel on local machine).
Based on my experiments i have written couple of Blogs here :
However, in Excel 2016 it doesn't seem to work. I get the error when i try to refresh. This was a good feature to be used by people who are happy with mini custom application driven through SharePoint.
Can anyone tell why this is not working now? and how to report this ?
Thank you..
Oct 02 2018 03:13 PM - edited Oct 02 2018 03:13 PM
Oct 02 2018 03:13 PM - edited Oct 02 2018 03:13 PM
Try this as your source step in Power Query, after replacing the parts in italics with your own info:
OData.Feed("https://yourdomain.sharepoint.com/sites/yoursite/_api/web", null, [Implementation="2.0"])