Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Good morning,
I have a data connection to a SharePoint site where I am bringing in a description field, free type box. When using in a table I have a line break where there is none in the source. I have unchecked "show whitespace" in Power Query, which has removed them in the display there, however still getting the break in the visual?
E.g. there should be no break after plan...
Thanks
Dan
Solved! Go to Solution.
@D_HL , In power query, try clean
Power Query Trim and Clean : https://youtu.be/NRYPsCnS0w4
@D_HL , In power query, try clean
Power Query Trim and Clean : https://youtu.be/NRYPsCnS0w4
Sorry @amitchandak it's now taken some spacing out and merged words together.... is there anyway to avoid that?
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |