Forum Discussion

markvsql's avatar
markvsql
Resolver 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
Community 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.