Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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?
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)
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
41 | |
26 | |
24 | |
19 | |
18 |
User | Count |
---|---|
52 | |
42 | |
24 | |
21 | |
20 |