Hi folks I'm at a road block. Imagine I'm importing a .xlsx file that has 2 columns, Col A and Col B. Col A text is not wrapped but Col B text is and there is NO delimiter between the the words that should contain a delimeter. When the file is imported some kind of internal transformation takes place since the Query Editor displays (for example) multiple rows for the wrapped text that appear to be recognized. eg. Col B contains multiple rows representing the seperated words but ALL within the one row.
As imported into PBI
Col A Col B
row1 word word1
row2 word word1
Before import row1, Col B contained "word1word2word3"