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

2 Replies

  • 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