Forum Discussion
Remove spaces without creating a new column
You can use replace method to replace a space with nothing if you are using Import mode with AS.
If you are using live connection mode with AS, there is no way to do so. You must try find a way to remove the space in AS before connecting to Power BI. Because live connection mode retrieves the entire AS model, you cannot access query editor to change the content, also dax is used to create new fields not to change existing column with dax. Hope that is clear.Best Regards
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
You can use replace method to replace a space with nothing if you are using Import mode with AS.
If you are using live connection mode with AS, there is no way to do so. You must try find a way to remove the space in AS before connecting to Power BI. Because live connection mode retrieves the entire AS model, you cannot access query editor to change the content, also dax is used to create new fields not to change existing column with dax. Hope that is clear.
Best Regards
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.