Forum Discussion

elimey's avatar
elimey
Icon for Helper I rankHelper I
3 years ago

export from table comes out with Blank space

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?
Need Help
GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
3 years ago

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's avatar
elimey
Icon for Helper I rankHelper I
3 years ago

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