How can i copy the Power Query table to an Array ?

%3CLINGO-SUB%20id%3D%22lingo-sub-2438259%22%20slang%3D%22de-DE%22%3EHow%20can%20i%20copy%20the%20Power%20Query%20table%20to%20an%20Array%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2438259%22%20slang%3D%22de-DE%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3EI%20get%20Data%20from%20a%20extern%20Excel%20file%20with%20Power%20Query%20I%20know%20I%20can%20bring%20this%20information%20to%20a%20sheet%20that's%20not%20the%20topic%20but%20I%20want%20to%20bring%20this%20information%20directly%20to%20an%20Array%20!%20How%20can%20I%20do%20that%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20i%20have%20the%20information%20in%20the%20Array%20I%20can%20send%20cell%20by%20cell%20the%20information%20to%20the%20excel%20sheet.%3CBR%20%2F%3EI%20need%20this%20option%20because%20if%20there%20still%20an%20information%20in%20the%20cell%20then%20it%20should%20not%20send%20the%20information%20in%20them%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2438259%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2438307%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20i%20copy%20the%20Power%20Query%20table%20to%20an%20Array%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2438307%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1076521%22%20target%3D%22_blank%22%3E%40Klaus1615%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAfraid%20that's%20not%20an%20option%2C%20Power%20Query%20returns%20data%20to%20table%20and%2For%20data%20model%20only.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello 

I get Data from a extern Excel file with Power Query I know I can bring this information to a sheet that’s not the topic but I want to bring this information directly to an Array !  How can I do that?

 

If i have the information in the Array I can send cell by cell the information to the excel sheet.
I need this option because if there still an information in the cell then it should not send the information in them

 

 

1 Reply

@Klaus1615 

Afraid that's not an option, Power Query returns data to table and/or data model only.