Forum Discussion
Unable to load text file in Power Pivot did Excel change?!!
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, P...
datafanatik , try importing using power query and see if you have any issues.
Consider uploading a sample file without any confidential information for further assistance.