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...
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.