Excel Export with live connection doesn´t support multi language reports?!

Hi BI2theRescue ,

The behaviour you are experiencing stems from the way Excel and Power BI handle language settings and functions. When you use Analyse in Excel, it preserves the language context because it interacts directly with the Power BI semantic model. When exporting data through an Excel export with a live connection, the process generates an Excel table that is not dynamically linked to the USERCULTURE function in the same way. This causes the data to be displayed in the base language of the report, rather than adapting to the user's current language settings.

To resolve this issue, consider the following workaround:

1. After exporting, manually adjust the language settings in Excel. While not ideal, this may be a temporary solution.
2. Since this is a limitation in the current function, providing feedback to Microsoft via the Power BI Ideas forum may lead to future enhancements in this area:Home (microsoft.com)
   
   

For more insight on how the USERCULTURE function works and its limitations, you can refer to the official documentation here:Use locale values in multiple-language Power BI reports - Power BI | Microsoft Learn

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.