Forum Discussion

markvsql's avatar
markvsql
Icon for Resolver I rankResolver I
10 years ago

Power BI Desktop Query Editor Hiding Leading Spaces (Trim)

I have a data source with varying amounts of leading spaces in a text field. it is attached as Figure 1.   Figure 1   You can see that mamy of the values have leading spaces in this Access da...
WillT's avatar
WillT
Icon for Community Admin rankCommunity Admin
10 years ago
Hi Mark. You'll find an option in the Query Editor to use a Monospaced font, which will show those spaces. We're tracking bugs to show them in the Data and Report views as well! Thanks Will
doktorg's avatar
doktorg
Frequent Visitor
10 years ago

Has there been any update on this. I have a similar problem but want to view trailing spaces, so when we export the data to csv the trailing white spaces are there.