none
Import from SharePoint List (Office 365 Wave 15 SharePoint Online)

    Question

  • 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
    Friday, October 18, 2013 8:15 AM

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
    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
    Saturday, October 19, 2013 3:17 AM
  • Hi !

    I'm having the same trouble here. Could you detail how you solved that problem?

    Thanks,

    Saturday, January 25, 2014 9:38 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.

    Saturday, January 25, 2014 10:31 AM
  • Thank you very much for your reply.

    I'll check with office 365 support how can I change the default language, so I can use power query.

    Saturday, January 25, 2014 10:58 AM