Unable to refresh the semantic model

[rachelbi]

Hi there, I fail to refresh the semantic model which should works earlier... and now showing below alert... can any expert help to advise please? ..

[amitchandak]

@rachelbi , seems like the column "contact" has been deleted or renamed, the same has been used in some of the power query steps like rename, data type change or formula. 

Please correct that and it should run fine

[rachelbi]

Thanks for your reply. But actually "Contact" column has not been used at the moment .. no idea why it impacts the dashboard view

[Anonymous · Accepted solution]

Hi @rachelbi 

Probably you don't use the "contact" column in the report, but if it is used by some Power Query steps using its name "contact", it will still cause this error after it has been removed or renamed at the data source side or at a step before where it is used in Power Query. 

If this semantic model was refreshed in the service successfully earlier, the "contact" column may have been changed at the data source side. Please check data at your data source database or file and recover "contact" column there with the same name and data type. 

If the "contact" column is not changed at the data source side, you need to check the Power Query steps in the semantic model. You can download it from service to your computer then open Power Query Editor to check and correct the steps.  Download a report from the Power BI service to Power BI Desktop - Power BI | Microsoft Learn After it has been corrected, republish the report to the service to replace the old one. Then the schedule refresh should work again. 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!