Answered by:
Import from SharePoint List (Office 365 Wave 15 SharePoint Online)

-
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
Question
Answers
-
I was able to resolve it myself.
It was working fine after creating English site and custom list.Power Query can import only English site.
Thank you.
- Marked as answer by Y Yoshikawa Saturday, October 19, 2013 3:17 AM
All replies
-
I was able to resolve it myself.
It was working fine after creating English site and custom list.Power Query can import only English site.
Thank you.
- Marked as answer by Y Yoshikawa Saturday, October 19, 2013 3:17 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.
-