Forum Discussion
chotu27
Post Patron
Post PatronTransformation,s in direct query mode for amazon redshift
Hi all,
Can we do below in Direct query mode
1.change column type
2.transformations
3. calculated columns
4. measures
Hi chotu27,
According to my test, they all can be done in Direct Query mode. But some complicate Calculated Columns and Measures might not be supported. "Transpose" and "Unpivot Columns" aren't supported. You can have a try.
Best Regards!
Dale
1 Reply
v-jiascu-msftMicrosoft Employee
Hi chotu27,
According to my test, they all can be done in Direct Query mode. But some complicate Calculated Columns and Measures might not be supported. "Transpose" and "Unpivot Columns" aren't supported. You can have a try.
Best Regards!
Dale