Forum Discussion

sailorman's avatar
sailorman
Frequent Visitor
3 years ago
Solved

Expression.Error

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...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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's avatar
Anonymous
Not applicable
3 years ago

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.