Forum Discussion
Data Failed to refresh
Received an odd error this morning during a refresh of my data in Power BI:
Offboarding has failed to refresh.
Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.
<ccon>Expression.Error: The column '<ccon>ID</ccon>' of the table wasn't found.. <ccon>ID</ccon>. </ccon>. The exception was raised by the IDbCommand interface. Table: ReturnRate.
I opened my queries in Power BI Desktop just to see if I could pull my most recent data without issue and it worked. Anyone know why this would be happening? My data pulls from two SharePoint lists and I haven't made any changes to the list columns.
5 Replies
Well we know the column "ID" in table "ReturnRate" was expected by Power BI Service and was not found. Only you researching your sources can answer why that happened and whether it's important.
The Power BI Desktop piece though, Desktop will due it's best to fix the Power Queries by modifying the Steps so that you can Refresh/Load...and then you can Publish to Service and it will work all a sudden, but it has made a change.
The Dataset in Service cannot fix itself in the same way and will just fail.
Hi thekeyjh ,
This issue has been confirmed as a known issue internally. Please be patient to wait for fixing. If there is any news, I will update it here.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi thekeyjh ,
A fix on this issue will be available around the mid-September release.
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi thekeyjh ,
Update：
The issue is already fixed in all regions and clusters in Service. A fix on this issue will be available around the mid-September PBI Desktop release.
As a workaround for Power BI Desktop for now, Customers can add the ID column back to the select statement within the M Query if customers are using ID column in "Table.SelectColumns" - Customers can remove the ID column within the M Query if customers are using ID column in "Table.RemoveColumns"
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi thekeyjh ,
Update:
The fix for PBI Desktop will come in the November version.
Fix for PBI Service is by December 2023.Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
