Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
147 | |
110 | |
108 | |
85 | |
64 |