Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

PBI export to CSV: number format exports wrongly

Hi all,   I have created a table visual in Power BI looking like this (European number format is set correctly in Power BI): Project Amount A 1.171,22 B 3.337,53   So far, so good...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Dear,

    I have found the issue! Apparently as my decimals were set to "auto" in Power BI, the number of decimals changed in a strange way when exporting to a CSV file, causing dots to arise where they shouldn't in the CSV file. When setting the number of decimals fixed to 2 in Power BI, the export works fine!

    Best regards,

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Dear,

I have found the issue! Apparently as my decimals were set to "auto" in Power BI, the number of decimals changed in a strange way when exporting to a CSV file, causing dots to arise where they shouldn't in the CSV file. When setting the number of decimals fixed to 2 in Power BI, the export works fine!

Best regards,