Forum Discussion
Rajashekhar Sheelvant
Aug 02, 2018Brass Contributor
Sharepoint list data imported into Excel 2016 using Odata:Does not refresh when published to Sharepo
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 t...
Olivier Travers
Oct 02, 2018Copper Contributor
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"])