Forum Discussion
Column name case issues
Hi, I have a visual(eg:table/matrix) created with datasource1 (Sql server) .This has column names with mixed case letters. And I have a datasource 2 (eg:aws) with similar columns but all column names in small case. when I tried repointing from data source1 to data source 2 ,though column names are same ,it breaks due to mixed case. Is there any solution without renaming to all small case or repointing again? I.. Any help is much appreciated. Thanks!
2 Replies
- parry2kSuper User
pbideveloper7 check this short video which actually addresses the same user case. It is less than minute 🙂
Table.TransformColumnNames - Power Query #powerquery #powerbi - YouTube
- pbideveloper7Frequent Visitor
Thanks for the reply.. No it doesnt help.. Transform column names doesnt help .It still breaks unless I rename or repoint it.