Forum Discussion

thomas_coltrain's avatar
thomas_coltrain
Frequent Visitor
4 years ago

Power BI Refresh Failed: Cross_Reference_No

Hey Everyone,

Since we just updated our Business Central to the latest version(cloud-based) over the weekend I keep getting Power BI refresh failures on my reports with BC saying(see picture), I have tried re-publishing, adding completely again to a different area, and I am having zero luck.  Any ideas?

Thanks!

 

Need Help

2 Replies

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi thomas_coltrain ,

    According to the error message, you might have some steps that reference the column 'Cross_Reference_No' which has been removed or renamed or any other operation when you modified the query. It could be a step where you renamed, re-ordered columns, changed data types, removed other columns, etc.

     

    Directly, in Power Query, right click on your query then select Advanced editor. Here you can see the name of columns/object used for each step of your query, find the unfound column name and edit it. 

     

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.