Forum Discussion
Problem with decimals when exporting underlying data to Excel
Hi all,
we are having problem exporting underlying data from a bar chart, from the Power BI service.
The data is exported correctly to Excel file, but when we open the Excel file the numbers of the calculated columns with amounts are multiplied by 100 (without the 2 decimal values)
In example, a value that in Power BI we see as 123.45, when exported to the underlying data in Excel is showed as 12345
Do you know if this is known issue or if we are misconfigurating something?
Tks for your help,
Hi v-haibl-msft, we found the problem finally, it was a mistyping on the SQL sentence on the source of the query, the underlying data export now works fine
Tks for your help!
Regards
4 Replies
I cannot repro the same issue on my side. Please refer to following screenshot. Could you please test with my sample PBIX file uploaded here? If it is specific to one of your reports, could you please share the PBIX file through online file service like OneDrive?
Best Regards,
HerbertHi v-haibl-msft, tks for your quick answer
I tested with your file and it works fine
Please test with mine here that is still failing
Tks for your return,
Hi v-haibl-msft, we found the problem finally, it was a mistyping on the SQL sentence on the source of the query, the underlying data export now works fine
Tks for your help!
Regards
