Make sure your column type is set to text when you are in the query editor.
Then right-click -> select transform-> trim.
Hope this is helpful. If you want to learn Power BI then check out Power BI Course Details now!
To save powerbi file directly to report ...READ MORE
Follow these steps to connect to data ...READ MORE
I use Devart ODBC drivers in order ...READ MORE
Follow these steps, to connect to IBM ...READ MORE
Do you want to show a table ...READ MORE
Click on edit queries after loading source ...READ MORE
There are the steps which you can ...READ MORE
Can anyone demonstrate how to split columns ...READ MORE
I can show some steps wise steps ...READ MORE
To do so, follow these steps:
From the ...READ MORE
At least 1 upper-case and 1 lower-case letter
Minimum 8 characters and Maximum 50 characters
Already have an account? Sign in.