Remove spaces without creating a new column

Hello Want to get a text string without spaces. Is connected to a "SQL Server Analysis Services Database" in Power BI sometimes the information is with spaces and sometimes without. As an ex...

Need Help

Anonymous
4 years ago
Anton-G

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.

Forum Discussion

Remove spaces without creating a new column

Related content

Creating date slicer removes data

Create table to remove duplicates

remove duplicate value within a row

Removing Duplicates

Remove trailing commas