Forum Discussion
PeterVanhoof
2 years agoNew Member
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
- lbendlinSuper User
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.