Forum Discussion
Change the data source from SQL server to Amazon redshift
Hi sonaliverma ,
Yes. I have created a test to reproduce such scenario.
1.Connect to Excel file1 with uppercase column names and then create visuals.
2.Replace Excel file1 with Excel file 2 which column names are lowercase.
3.Handle errors in Power Query.
4.After applied changes, the visuals are needed to fix.
I think it's the expected output since the visuals could not find the fields any more.
And according to my researching, you could firstly change the column names to uppercase before you do any transformations by using :
RenamedColumns = Table.TransformColumnNames(Source, Text.Upper),Then you don't need to re-arrange the vsiuals.
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.It's an expected behaviour.
Hi sonaliverma ,
Yes. I have created a test to reproduce such scenario.
1.Connect to Excel file1 with uppercase column names and then create visuals.
2.Replace Excel file1 with Excel file 2 which column names are lowercase.
3.Handle errors in Power Query.
4.After applied changes, the visuals are needed to fix.
I think it's the expected output since the visuals could not find the fields any more.
And according to my researching, you could firstly change the column names to uppercase before you do any transformations by using :
RenamedColumns = Table.TransformColumnNames(Source, Text.Upper),Then you don't need to re-arrange the vsiuals.
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
It's an expected behaviour.