Unable to load text file in Power Pivot did Excel change?!!

%3CLINGO-SUB%20id%3D%22lingo-sub-1510260%22%20slang%3D%22en-US%22%3EUnable%20to%20load%20text%20file%20in%20Power%20Pivot%20did%20Excel%20change%3F!!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1510260%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I'm%20attempting%20to%20load%20a%20text%20file%20into%20Power%20Pivot.%3C%2FP%3E%3CP%3EI%20also%20cannot%20load%20a%20text%20file%20into%20Excel.%3C%2FP%3E%3CP%3EIt%20appears%20that%20it's%20not%20recognizing%20the%20field%20separator.%3C%2FP%3E%3CP%3EI've%20used%20field%20separators%20like%20Tab%2C%20Pipe%20%7C%2C%20Colon%20%3A%2C%20etc%20and%20they%20don't%20work.%3C%2FP%3E%3CP%3EIt's%20combining%20the%20line%20into%20one%20column.%3C%2FP%3E%3CP%3ESee%20screenshot.%3C%2FP%3E%3CP%3EIt%20appears%20MS%20may%20have%20made%20some%20changes%20to%20Office%20365.%3C%2FP%3E%3CP%3ECan%20anyone%20chime%20in%20on%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1510260%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1510609%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20load%20text%20file%20in%20Power%20Pivot%20did%20Excel%20change%3F!!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1510609%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722833%22%20target%3D%22_blank%22%3E%40datafanatik%3C%2FA%3E%26nbsp%3B%2C%20try%20importing%20using%20power%20query%20and%20see%20if%20you%20have%20any%20issues.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22TheAntony_0-1594265761670.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F204286iE2EB692F1F81610E%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22TheAntony_0-1594265761670.png%22%20alt%3D%22TheAntony_0-1594265761670.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EConsider%20uploading%20a%20sample%20file%20without%20any%20confidential%20information%20for%20further%20assistance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi, I'm attempting to load a text file into Power Pivot.

I also cannot load a text file into Excel.

It appears that it's not recognizing the field separator.

I've used field separators like Tab, Pipe |, Colon :, etc and they don't work.

It's combining the line into one column.

See screenshot.

It appears MS may have made some changes to Office 365.

Can anyone chime in on this?

 

Thanks!

 

2 Replies

@datafanatik , try importing using power query and see if you have any issues.

TheAntony_0-1594265761670.png

 

Consider uploading a sample file without any confidential information for further assistance.

 

Highlighted

@datafanatik 

That's a known bug, this connector works only with commas.

 

In general these days better not to use Power Pivot connectors, Power Query gives much more possibilities.