Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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