export from table comes out with Blank space

[elimey]

I have atable in PowerBI service, 

When I export to Excel, the values in Model columns are coming out with a ' ' space before the models, very randomly.

Does anybody know why?

[GilbertQ]

Hi @elimey 

That is quite possibly because you have this in your data.

If you can go into Power Query and on the column, click on Transform and then Trim (which will remove any white spaces from your text at the start and end)

[elimey]

Hi @Gilbert

I have checked my data several times, the problem is not with the data. 

for instance, if you look at the image above the model 'NX' is appearing once with the empty character before, and once without