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

[SJRJEJ]

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?

There are a few articles using excel as a datasource , where the column name of the underlying excel table has changed , but those steps don't seem to work with SQL Server as  a data source .

To elaborate , if my PowerBi report were based on a table Sales2023 with columns

• ProductId 
• Qty
• TotalSales2023

If the table in SQl Server get renamed from Sales2023 to SalesCurrYr and the columns get renamed to 

• ProductId 
• Qty
• TotalSales

the PowerBI report breaks when the report is refreshed after the DB change.

Any advice is much appreciated.

[tmhalila]

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]

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]

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?