EXCEL 2016 Power query Errror when CLOSE AND LOAD

Question

In Excel 2016 when I create a simple query ( select * from table1) in power query editor it runs Ok and load all the data.

But when select close and load only get a few rows and get an error:

"Error initialization data source"

Eugene · Accepted Answer · 2016-07-07 18:16:59Z

1

This is probably because you see only few rows in preview, and error is encountered later on. Try browsing a hundred of rows, or more. If you won't get that error, you need to post more details - what datasource do you query, for example.

answered Jul 7, 2016 at 18:16

Eugene

1,2641 gold badge12 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

EXCEL 2016 Power query Errror when CLOSE AND LOAD

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related