Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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? ..
Solved! Go to 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!
@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
Thanks for your reply. But actually "Contact" column has not been used at the moment .. no idea why it impacts the dashboard view
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!
User | Count |
---|---|
84 | |
71 | |
71 | |
68 | |
55 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |