Problem with decimals when exporting underlying data to Excel

[cavalierimauro]

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,

[cavalierimauro · Accepted solution]

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

[cavalierimauro]

Hi @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,

[v-haibl-msft]

@cavalierimauro

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,
Herbert