Change the data source from SQL server to Amazon redshift

[sonaliverma]

Hello Everyone,

I need to change the data source in PowerBI from SQL server to Amazon redshift, But all the columns in Amazon redshift are in lowercase, and on SQL sever it is in another case.

When I changed the data source, I lost all the fields in the visual and it is showing an error. I need to again take the fields in the visual.

Could you please suggest any method?

[Anonymous · Accepted solution]

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.