change in column names in original datasource

[KV2022]

Please help.

I loaded some queries into data model. Created visuals. Now some of the column names in the fact table have been changed.  I created a new odbc connection to the postgres and changed data source settings. But still my queries are not getting loaded. I am getting error regarding the old column names. I am not able to get any data in my visuals.

[amitchandak]

@KV2022 , Add the table again as a new source, and rename columns so that they get the same as the old one. Now Open advance editor (Option on right click- In Power query editor), Take the first few steps and replace them in old script, match the table names

I have explained that in this video -

Change Connection from One source type to another Source Type: https://youtu.be/nwYJgG2hmd0

[KV2022]

I changed the data source settings and it worked. Thanks a lot.