Forum Discussion

SJRJEJ's avatar
SJRJEJ
New Member
2 years ago

PowerBi Refresh failing as underlying SQL server table and column renamed in the DB

Hi ,  I have a PowerBI dashboard that is now broken because the tables and columns in the dataset have been renamed in SQL Server. How can I propogate those changes in the DB to my PowerBI report? ...
Need Help
tmhalila's avatar
tmhalila
Resolver II
2 years ago

Usually, an additional column is not the case, but when the column or a table is renamed, you also have to rename it from the Power Query side of your Power BI click on the source then change the table name! Below is the screenshot to rename the table, for columns you only need to double-click the column name and rename accordingly.

Hope your problem is solved.

SJRJEJ's avatar
SJRJEJ
New Member
2 years ago

Thank you for your response. Since my source is SQL Server , PowerQuery references the new columns when the source is refreshed . The error is on the report , the report still references the old name and gives an error about the old column name missing from the data source . 

  • tmhalila's avatar
    tmhalila
    Resolver II
    2 years ago

    If Power Query references the new column that means your dashboard was refreshed successfully but you are getting challenged with some measures that reference the names of the old columns! Can you screenshot the error msg?