Forum Discussion
Expression.Error
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.
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.
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.