Initialization of data source failed

%3CLINGO-SUB%20id%3D%22lingo-sub-1477707%22%20slang%3D%22en-US%22%3EInitialization%20of%20data%20source%20failed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1477707%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20currently%20trying%20to%20append%20multiple%20.csv%20flies%20located%20in%20a%20folder%20on%20my%20desktop%20using%20Power%20Query%20in%20Excel%202016.%20Each%20file%20contains%207%20columns%20and%20around%20300%20rows%20of%20data.%3C%2FP%3E%3CP%3ETesting%20this%20with%20two%20files%20the%20Power%20Query%20preview%20shows%20it%20has%20pulled%207%20columns%20and%20583%20rows%20of%20data.%3C%2FP%3E%3CP%3EThis%20seems%20correct%20and%20no%20errors%20showing%20this%20data.%20I%20can%20even%20scroll%20through%20the%20data%20down%20to%20row%20428.%20This%20is%20where%20Excel%20truncates%20the%20data.%26nbsp%3B%20I%20can%20also%20%22refresh%20the%20preview%22.%20It%20seems%20to%20me%20that%20Excel%20can%20see%20the%20data%20fine%3C%2FP%3E%3CP%3EOnce%20I%20click%20the%20%22Close%20and%20Load%22%20button%20I%20get%20the%20attached%20error.%26nbsp%3B%20%22Initialization%20of%20data%20source%20failed.%20Check%20your%20database%20server..........%22%20See%20attached%20screenshot%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHas%20anyone%20seen%20this%20issue%20and%20know%20how%20to%20fix%20it%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1477707%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I am currently trying to append multiple .csv flies located in a folder on my desktop using Power Query in Excel 2016. Each file contains 7 columns and around 300 rows of data.

Testing this with two files the Power Query preview shows it has pulled 7 columns and 583 rows of data.

This seems correct and no errors showing this data. I can even scroll through the data down to row 428. This is where Excel truncates the data.  I can also "refresh the preview". It seems to me that Excel can see the data fine

Once I click the "Close and Load" button I get the attached error.  "Initialization of data source failed. Check your database server.........." See attached screenshot

 

Has anyone seen this issue and know how to fix it?

 

Thanks in advance,

0 Replies