Get data "From online Services" - Option disabled

%3CLINGO-SUB%20id%3D%22lingo-sub-2340831%22%20slang%3D%22en-US%22%3EGet%20data%20%22From%20online%20Services%22%20-%20Option%20disabled%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2340831%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20export%20a%20list%20from%20sharepoint%20to%20excel.%20However%20when%20I%20open%20the%20file%20that%20is%20being%20generated%20%22.iqy%22%2C%20it%20opens%20only%20the%20headers%20of%20the%20table%2C%20with%20no%20information.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20import%20it%20through%20the%20excel%20option%20%22Data%20--%26gt%3B%20Get%20Data%20--%26gt%3B%20From%20online%20Services%22%20but%20the%20option%20%22From%20online%20services%22%20is%20disabled.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20know%20how%20to%20fix%20it%20or%20at%20least%20explain%20me%20the%20reason%20why%20the%20list%20is%20not%20being%20properly%20generated%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2340831%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Frequent Visitor

I'm trying to export a list from sharepoint to excel. However when I open the file that is being generated ".iqy", it opens only the headers of the table, with no information.

 

I'm trying to import it through the excel option "Data --> Get Data --> From online Services" but the option "From online services" is disabled.

 

Does anyone know how to fix it or at least explain me the reason why the list is not being properly generated?

 

Thanks in advance!

0 Replies