Power Table Formatting

I am binding a power table data through an sql query. Sql data type is char(50) but actual data length is only 10 char long. If I use TRIM command in sql query, I lose column headings in power table. Is there a different work around to trim data in power table?


In your query just use AS after the RTRIM

Select RTRIM(MyFieldName) as MyFieldName

Got it. Thank you very much.