I want to import SharePoint list from SharePoint Online with Power Query Preview for Excel. (Power Query ver. 2.8.3443.101)
But not display any custom list and no error message.
I connect with Microsoft Online Services ID.
There are 5 list in this site.
Please tell me how to import from SharePointOnline.
- Edited by Y Yoshikawa Friday, October 18, 2013 8:20 AM
There is currently a limitation in Power Query's support for SharePoint: it only works for sites whose default language is English. You can have additional languages configured, but the default language -- which must be set when the site is created, I believe -- must be English.
Unfortunately, while it's a very high priority for us to find a solution, this is a tricky problem to fix. So it's not possible at this time to suggest when a fix might be available.