Hi, @Cyrex
According to your description, you are using ODBC to extract data with data formatting error, you can try to take the following approaches to solve this problem.
1. Use a custom format string to explicitly define the format for decimal values. In your example, you want the number '16.891,78' to be formatted correctly, you can use the format string '0.00'. This will ensure that your decimal values always display at least one digit to the left of the decimal separator and at least two digits to the right.
Related link: Use custom format strings in Power BI Desktop - Power BI | Microsoft Learn
2. If the area setting change did not affect the decimal format, it may be because the system's number formatting settings were not updated or recognized based on the new area setting. Ensure that the system's number format settings are set correctly.
3. Review the ODBC data extraction. Since you are extracting data directly from the view via ODBC, make sure that the data format is correctly interpreted during the data extraction process. Sometimes, formatting issues can stem from the way the data is imported into Power BI. When pulling data through ODBC, you can use either the data source name (DSN) or the driver connection string.
Related link: Power BI gateway and Report Builder support for ODBC data sources - Power BI | Microsoft Learn
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
