Forum Discussion

AnandNamburi's avatar
AnandNamburi
Helper III
4 years ago

M code to add a column new column from SQL DB

Hi All,   I have a table called "Service" and it was imported in to Power Bi. After importing, backend team has modified 2 coulmns in the same table. So when I opened the dashboard it is throwing e...
Need Help
Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago

Can you post your m code? There are various ways to solve this issue. For example, you can rename back those columns to old names before those are used in your code so no futher code modification is required (but it depends upon your situation)

AnandNamburi's avatar
AnandNamburi
Helper III
4 years ago

Hi Vijay,

 

The M code is below

 

let
Source = Sql.Database("Anand092.database.windows.net", "Anand092"),
edwmrtanand_service = Source{[Schema="edwmrtanand",Item="service"]}[Data],
#"Renamed Columns" = Table.RenameColumns(edwmrt_service,{{"Clm", "Claim"}, {"Hlth", "Health"}, {"Srvc", "Service"}})
in
#"Renamed Columns"

 

In the table is service.

Suppose if a new column say "Column 1" gets added then how can I accomodate it in M code

  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    Most Valuable Professional
    4 years ago

    If Column1 is a new addition to the table, then unless you use it in your code, it will not impact you. For example, in your code, if you add a new Column1 and  when you refresh your query, it will not have any impact as you are not using Column1 anywhere.

    But suppose Column1 was already existing and its name is changed to Column_1 then, in Rename Columns add this also {"Column_1", "Column1"}, then whereever you are referring to Column1 in your code, that will not be impacted.

    Having said that I am not sure if it answers your questions as I feel that I am missing something. Let me know what is that.