Forum Discussion

Urs's avatar
Urs
Frequent Visitor
3 years ago
Solved

Dataverse - Currency Fields - Error converting data type nvarchar to numeric - Bug?

Hi there since some days (I think since the February 2023 release) I experience an Error when multiplying a Dataverse Currency Field with a numeric value. This happens in both Power BI Desktop and P...
Need Help
  • Urs's avatar
    Urs
    3 years ago

    Just had a call with Microsoft Support. They fixed the issue in the backend and it works now.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

I'm running into the same issue...were you able to find a solution?

Urs's avatar
Urs
Frequent Visitor
3 years ago

Unfortunately, the problem still exists.

 

A possible, but in my opinion bad workaround, is not to do the calculation in Power Query, but to do it in a Calculated Column in the dataset.

  • Steph999's avatar
    Steph999
    Frequent Visitor
    3 years ago

    I tried this, and the problem presists outside of power query. Very odd...