Forum Discussion

YoyoZhang's avatar
YoyoZhang
Regular Visitor
2 years ago

Two same data text become different text after publishing to service

Hi everyone,

 

In my table, the item code '1205-EKB0004' has two rows, so it shows like this in the PBI desk which has no problem.

 

But after I published this report into the PBI service, and open it in the service, it becomes two different text. Can you help me to solve this? Thank you so much.

 

 

 

1 Reply

  • Hi YoyoZhang 

     

    Can you make sure to TRIM your text field in Power Query to make sure that there are no leading or trailing white spaces?