Forum Discussion
Column Text Manipulation
Unfortunately most text manipulation steps in Power Query do not work with Direct Query. Your only two alternatives are to fix the data a the source (which you said wasn't possible), or switch to Import Mode, which will let you do just about anything you want.
Even in DAX there are features that become limited with Direct Query. It is mean for very specific purposes. Generally Import is the way to write most reports.
Community ChampionUnfortunately most text manipulation steps in Power Query do not work with Direct Query. Your only two alternatives are to fix the data a the source (which you said wasn't possible), or switch to Import Mode, which will let you do just about anything you want.
Even in DAX there are features that become limited with Direct Query. It is mean for very specific purposes. Generally Import is the way to write most reports.
Thank you edhans for the prompt response 👍
