Expression.Error

[sailorman]

I have a report that refreshes on Power BI desktop with no issues. However, when I ulpload it to service and refresh online it fails with the below expression error. Please shed some light on what is causing this issue online and how to resolve this

Expression.Error: The column '<ccon>ID' of the table wasn't found.. ID. </ccon>. The exception was raised by the IDataReader interface.

[vivisiratuti]

I have the same problem and I do not know how to fix it. Was anybody able to solve this? (I read this post and some solutions are about sharepoint list, but my data is an online excel spreadsheet.

[Anonymous · Accepted solution]

Hi @sailorman ,

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.

[Anonymous]

Hi @sailorman ,

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.

[Anonymous]

Hi @sailorman ,

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.

[Anonymous]

Hi @sailorman ,

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.

[Mark_]

I have had exactly the same issue since Saturday but with a new SharePoint list! we are not using SharePoint Classic.  The fix seems to be as someone above also suggested:

• Make sure the ID column is visible on your SharePoint list in Sharepoint and at position 1 from the left.
• In the Power BI Query editor, you will find a step has been added to remove the ID column, remove this step or reference to the ID column from this step so that it is not deleted from your data model for any SharePoint list.
• Republish your report and refresh should work again for now!

Hope this helps, although very annoying that MS has obviously made a change that has a significant impact without understanding the implication of the change made before implementation.

[ClaraVL]

Confirming making the ID columns visible works here also as workaround.

I've had to update both SharePoint Online and SharePoint 2010 on prem queries.

[sulleyinoz]

@sailorman , @ClaraVL 

This might be related to this issue reported a couple of days ago if it used to refresh and has now stopped with no changes.

https://community.fabric.microsoft.com/t5/Service/Power-BI-Service-Dataset-Refresh-Error-Expression-...

[sailorman]

I am not using a gateway. I am using the current version of Power BI desktop. And the refresh is normal while on desktop. I have made sure my connections are good in service. However the refresh fails.

[GilbertQ]

Hi @sailorman 

Can you make sure you have got the latest version of the Power BI gateway installed (if you are using it)?

[ClaraVL]

I'm encountering the exact same issue. Also since yesterday. Using a SharePoint on-prem (2010) list as datasource.

Have upgraded the gateway (which was indeed outdated) but this has not resolved the issue. The same error persists.