Forum Discussion

PeterVanhoof's avatar
PeterVanhoof
New Member
2 years ago

Exporting data from a PowerBi delivers wrong values in Excel.

= results in Excel

= results in PowerBI Visual


E.g. 391.035.750,29 from PowerBi becomes 39.103.575.029.456.500 ... so I've to divide by 100.000.000 to get to 391.035.750,29
E.g. 2.048,51  from PowerBi becomes 204.851... so here I've to divide by 100 to get 2.048,51

 



Please help 😉

 




1 Reply

  • You have a locale mismatch between the Power BI service and your local Excel instance. There's no simple fix - you'll have to try changing the Excel locale first.