Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All, I have a client-specific requirement where I need to develop the pbi report exactly the same as the mainframe report. The trailing spaces are intact in the data preview (power query editor) whereas they are getting removed while in the report view. I need to keep the trailing spaces as it is without removing them in the report view.
Please note the data below are part of data in text format and they are not seperate columns
For example - The data should look like below - (Expected)
DD ST RMV ADD SEQ FLT FLT SKED STTL ACT GRTR GTTL
02 11 XX YY
03 11 XX YY
The data in the report looks like below (actual)
DD ST RMV ADD SEQ FLT FLT SKED STTL ACT GRTR GTTL
02 11 XX YY
03 11 XX YY
Can someone help me with the solution.
Regards,
Suneeta
Add an invisble-ish unicode character to the end of your strings?
User | Count |
---|---|
17 | |
11 | |
5 | |
4 | |
3 |